Data Source is pulling only 1000 records from LDAP server

[Suresh1]

Hi Guys,

I have connected to LDAP server and then created OU definitions. I also created data source for it and then when i click on 'Load all records' , SNOW is pulling only 1000 records. 

I have enabled 'paging' but it doesn't help. LDAP OU definition i cannot be able to create smaller queries as there might be lot of records.

I raised SNOW support case and they are unable to provide root cause of the issue and they pointed me to below link

https://hi.service-now.com/kb_view.do?sysparm_article=KB0657310

to create LDAP v3 pagination. What is this LDAP V3 Pagination?

If anyone came across this issue, please let me know.

Thanks

[Community Alums]

1000 is the default limit unless you turn on paging.

When paging is on, you may have multiple result sets, so you should have a look to see if there are more than one result sets returned, as you may have many, but all capped at 1000 or less. 

https://docs.servicenow.com/integrate/ldap/reference/r_LDAPQueryLimits.html

[Sushant Kadam1]

Hi Suresh,

Configure the LDAP server by enabling 'Paging' checkbox as shown in below screenshot.

Please mark correct/helpful based on the impact.

Regards,

Sushant

[Suresh1]

Hi Sushanth/Aidan,

I have already set the paging to true and still its not solving the issue. Always only 1000 records are getting imported.

Thanks,
Suresh

[Community Alums]

Hi Suresh, yes you will only ever get max 1000 per page.

If for example you have 2340 records returning, it may return in multiple "pages"

• 1000
• 1000
• 340

That is why I mentioned to look for multiple result sets that may have been created from the one load.

Cheers,