Why my CMDB Query Builder result always shows upto 10,100+ records only?

[Daisy Licup]

Dear Experts,

Need your kind advice on this.

Using Query Builder, I am trying to develop a query that will show all Database Instance and its related Server. 

I have around 50K db instance records but when relating to Server (which also has 50K records), the result is just showing me 10K. I am expecting 50K records as result. I tried many tweaking of the query but it never goes up to 10,200 records. 

Why my CMDB Query Builder result always shows upto 10,100+ records only? Is this some kind of limitation? Or is there any settings needs to be changed to show all result? Please help to assist. Thank you.

 CMDB Query for DB Instance to Host Mapping:

[Maik Skoddow · Accepted solution]

Hi

on page https://docs.servicenow.com/en-US/bundle/sandiego-servicenow-platform/page/product/configuration-man... you can find the system property glide.cmdb.query.max_results_limit which limits the number of results. Modify that property accordingly.

Maik

[Daisy Licup]

Thanks @Maik Skoddow for your prompt response. 

Will engage with sys admin to modify the max result limit as advise. thanks!