Crystal reporting on active directory and page size limits
Posted on 2003-03-12
I am trying to develop a reporting solution for our very large active directory infrastructure using Crystal Reports Dev 8.5. We have hundreds of thousands of objects in our Active directory and currently no means to report against it.
Using Crystal 8.5 Dev I have managed to connect to the active directory using the below logic.
ADO data connection using ADSDSOObject as the server and the following ldap query as the recorset that is fetched.
SELECT name, adspath, givenName, Department, EmployeeID, HomeDirectory, cn, displayName, middleName, initials, company, title, department, streetAddress, postOfficeBox, l, st, postalCode, c, mail, otherMailbox, telephoneNumber, homePhone, mobile, pager, facsimileTelephoneNumber, wWWHomePage from 'LDAP://DC=Domain,DC=com' WHERE objectClass = 'user'
This allows me to pull in records up to 1000 total then it stops. I suspect this is related to a maximum page size limit set on our domain controllers. I see the same limit on a linked SQL server I have also set up.
My question is...
Is it possible through this or a similar mechanism to specify a page size in the ldap string, or some other way to return more than the current 1000 rows I am seeing?
Am I chasing a dead end?