[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Querying more than 1000 records from Active Directory  XML
Forum Index » General Discussion
Author Message
melissa



Joined: 01/10/2009 14:38:08
Messages: 6
Offline

I need to export more than 1000 records at a time. How can I do this with the AD Admin and Reporting tool? I have a SQL query that returns what I want but I cannot get all of the records I need.

This message was edited 1 time. Last update was at 10/11/2009 22:19:11

support



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

AD Admin & Reporting tool supports pagination which lets you export more than 1000 records from AD.
If you are unable to export more than 1000 records AD may be missing required controls, in that case try the following:

1. Modify the sql so that it runs at the immediate container level and not on RootDSE (Try second option if this does not work).
2. Increase MaxPageSize (http://support.microsoft.com/kb/315071) and disable Enable Ldap Paged Result control from Preference|General (Last check box)
 
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