Active Directory Load Issue

[Anonymous]

Dear Experts,

I am trying to access the list of active directory users by below code.

Though its working perfectly I have two questions.

1.Why it shows the script error as "OLEDB read failed"?

2.Why it is loading only 1000 Users details only?

Load *,SubField(distinguishedName, ',') As Properties;

SQL SELECT

displayName,

distinguishedName,

SAMAccountName,

mail,

userPrincipalName,

SN,

givenName,

physicalDeliveryOfficeName,

userAccountControl

FROM 'LDAP://mydomain.local'

Regards

Jeba

[#2]

The LDAP server is preset to 1000 in maximum number of objects that are returned in a single search result (MaxPageSize).

So, you must to change this using "ntdsutil.exe". The max value is 262,144.

Follow this: How to view and set LDAP policy in Active Directory by using Ntdsutil.exe

[Anonymous]

Thanks.I am working on the changes you have guided and confirm if there is any issue