Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Can't load more then 1000 users from Active Directory using SQL
Article Number: 000005270 | Last Modified: 2019/10/29Description
When loading Active Directory users via SQL, only 1000 users are loaded.
Resolution
The LDAP server is preset to 1000 in maximum number of objects that are returned in a single search result (MaxPageSize).
Change this using for example "ntdsutil.exe"
The max value is 262144.
Instructions can be found on the Microsoft Site: How to view and set LDAP policy in Active Directory by using Ntdsutil.exe
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us