[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Export Disabled Users/Accounts from Active Directory  XML
Forum Index » General Discussion
Author Message
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?
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.
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))
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

Make sure that you don't have any spaces after the last )
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
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.
ka1972



Joined: 12/01/2009 18:58:13
Messages: 7
Offline

Thanks, it is now working!!
 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team