topic Re: Active Directory Load Issue in QlikView

Active Directory Load Issue

Anonymous — Fri, 04 Jul 2014 11:45:31 GMT

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

Fri, 04 Jul 2014 12:00:00 GMT

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.

Anonymous — Fri, 04 Jul 2014 15:05:44 GMT

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