Report unable to export more than 10000 rows

[Aaryan1]

Hi,

We have more than 10000 records in incident table. and I want to fetch a report of all the incident.
but as export limit is 10000 how can i fetch all the records.

[Allen Andreas]

Hi,

Please see this documentation that speaks of the system property that is limiting some types of exports to 10,000 rows. You can increase them: https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/exporting_data/concept...

Please mark reply as Helpful/Correct. Thanks!

[AbhishekGardade]

Hello Aryan,

Exporting to Excel is actually limited by 2 system parameters: glide.excel.export.limit and glide.excel.max_cells. So, if you increase the default 10000 to 80000 of row limit, you might still not get all data as by default the cell limit is 500000. You might need to increase that value as well. However, keep in mind that Excel itself has a limit of how much data can it display when you open the file.

1. Go to System Properties => Import Export

2. Change the Export Row Limit value to 80000

3. Change the Export Cell Limit (as needed)

FYI, when dealing with such large files, I will recommend using CSV instead of Excel. Excel is good for small result sets but limited when it comes to moving large amount of data between systems.

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/exporting_data/concept...

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[Aaryan1]

Hi Abhishek,

Will it not impact the system performance, if i change the export limit to 50000

[Ryan_Gillespie]

It can, yes. We initially had it set to 100k given the massive size of our instance, then had to go down to 50k and back down to 10k.