Increase Export Limit with CMDB Query Builder

[lakshmin]

I am trying to increase the Export Limit of CMDB query builder export results , Currently it is exporting only 10000 rows.

I read that it can be increased to a preferred number by using glide.cmdb.query.max_results_limit sys property

I had set this property to my number but still the file stops at 10k rows , are there other system properties that impact this

Any pointers?

[Moy1]

trying using system properties>import export

[lakshmin]

thanks Moy 

But i dont see an option to configure specifically for the CMDB query builder , In our system we had increased the XLS to 300000 on the Import Export settings page , but nothing for CMDB Query builder export limit and I dont see a "New"

[Guilherme Corre]

Step 1 - Increase Excel Limit

- Navigate to System Properties > Import Export.

- Change Export Row Limit value for Excel Format (.xls) / Excel Format (.xlsx)

OR directly on sys_properties : glide.excel.export.limit / glide.xlsx.export.limit

Step 2 - Increase Query Builder Export Limit

- Navigate to Configuration > CMDB Properties > Query Builder Properties

- Increase "Limits the number of results for a scheduled query and in the results section in the Query Builder when you click Load All Results."

OR directly on sys_properties : glide.cmdb.query.max_results_limit