Author |
Message |
12/01/2009 19:02:03
|
ka1972
Joined: 12/01/2009 18:58:13
Messages: 7
Offline
|
How can I only export list of disabled users/accounts from active directory using ldap admin tool?
|
|
|
12/01/2009 19:23:48
|
support
Joined: 27/06/2008 19:01:18
Messages: 123
Offline
|
To export all Active Directory disabled user
Select a top level container (not RootDSE) from the left hand explorer window and select export->Excel Export from the right hand context menu and follow the following steps:
1. Enter the name of the Excel file
2. In the filter text box remove (objectclass=*) and paste the following:
(&(objectCategory=Person)(objectClass=User)(userAccountControl:1.2.840.113556.1.4.803:=2))
3. Select the attributes to return or leave it to default.
Click Finish.
-------------------------
To Search for all disabled user
Right Click RootDSE (Top left in the explorer window) and Select Search. In the dialog click the Text Filter tab and paste the following
(&(objectCategory=Person)(objectClass=User)(userAccountControl:1.2.840.113556.1.4.803:=2))
Click Search.
To search specific container select a container to search and select search from the right hand context menu.
|
|
|
12/01/2009 19:26:42
|
ka1972
Joined: 12/01/2009 18:58:13
Messages: 7
Offline
|
I got a filter error when I copied and pasted the following in the search dialog
(&(objectCategory=Person)(objectClass=User)(userAccountControl:1.2.840.113556.1.4.803:=2))
|
|
|
12/01/2009 19:28:43
|
support
Joined: 27/06/2008 19:01:18
Messages: 123
Offline
|
Make sure that you don't have any spaces after the last )
|
|
|
12/01/2009 19:36:58
|
ka1972
Joined: 12/01/2009 18:58:13
Messages: 7
Offline
|
OK Search is working now but when I tried to export to excel as per the instructions I got the folowing error
BufferOverflowException -- Unable to convert some characters while exporting the records
|
|
|
12/01/2009 19:42:12
|
support
Joined: 27/06/2008 19:01:18
Messages: 123
Offline
|
As the error says there is some data which the export process unable to convert to excel format.
Try exporting in the csv format or limit the number of attributes to export.
To limit the number of attributes
1. Select the browse button on the right hand side of 'Returning Attributes' text box
2. Select a few attributes like distinguishedName,cn,description,mail,creationTime,co,company,department,displayName,homeDirectory,homeDrive
Click Finish.
|
|
|
12/01/2009 19:49:44
|
ka1972
Joined: 12/01/2009 18:58:13
Messages: 7
Offline
|
Thanks, it is now working!!
|
|
|
|