Skip to Content
Former Member
Jul 13, 2009 at 07:49 PM

Active directory connection not returning all objects/users


We have a custom AD field called "Employee ID.''

It's populated with (surprise!) all employees' ID numbers. They all start with "99."

When I set up a OLE / Active Directory connection, and type in this command:

SELECT eMPLOYEEid, SN, GIVENNAME, MAIL, DEPARTMENT, MODIFYTIMESTAMP FROM 'LDAP://dc=mydomain,dc=k12,dc=ga,dc=us' where employeeID = '99*'

Crystal returns exactly 1000 records.

Not all of my people are there.

What do I need to change to enable the return of ALL of my employees, from Active Directory?