Thursday, October 31, 2013

How to get a list of all Disabled Users?

There are 3 ways to get a list of all Disabled users in the system



1. Command Manager


LIST LOGIN, ENABLED FOR USERS IN GROUP "Everyone";


Users that have a value of false for the property "enabled" are disabled users


2. Enterprise Manager

Create a report with "User" attribute. "Enabled Status" is an attribute of the user  


3. Statistics Database

Select
          distinct u.EM_USER_ID  EM_USER_ID,
u.EM_USER_NAME  EM_USER_NAME,
u.EM_MODIF_DATE  EM_MODIF_DATE,
u.EM_ENABLED  EM_ENABLED
From  Em_User u
Where u.Em_Enabled = 0;


No comments :

Post a Comment