Has anyone been successful at exporting more than 10000 rows of data from a list report?

[angeladriscoll]

I have a list report that has about 85000 rows which I need to bring into excel to manipulate. I choose export and it emails me the report, however, there seems to be a maximum of 10000 rows of data it exports.

[Shane J]

This is likely your issue:

Export limit properties

10k is the default limit.   Though I have had issues with large exports, even after modifying these...

[Josh Cooper]

As Jued pointed out, it's a system property that you can configure - you'll just want to be careful when modifying these just because they have potential to tie up more resources for an extended period of time.   It seems like 85k rows would be within the realms of reason, as long as you're not wanting it every 15 minutes or something.   Take normal precautions for large data, try to schedule the report in an offpeak time, etc, and it should be fine.

Vast and enormous sums of data though runs into additional problems, so you still would want to be careful raising thresholds.   We had an issue in the past where it was recommended to increase the threshold for Performance Analytics from 500k records to 12.5M to get the out of the box CMDB counters working, and the result was that it took 11 hours, and caused issues on the instance itself due to shared memory space.   If you have large amounts of data you need, you may need to be a little creative - i.e. subdivide it if necessary and reassemble in Excel if you have to.

[HugoFirst]

I've had good luck "paging" the exports when the number of records exceeds 10,000.

I like this option better than increasing the max records, because eventually, you'll hit the new limits.

See Break up a large export   for information about this.

There's also a page on exporting using a URL with information about using sysparm_orderby and   sysparm_query on the sys_id:

Export directly from a URL

There's also a good discussion about exporting using wget.   This would be more of a pull, then a push as is the case with a report.

But it works:

Re: Exporting data using wGet

[Ravish Shetty]

i created a utility ui page and script include to help me with this.

It creates links by adding special filters based on sys_id to segregate the data in the chunks of 10K (default). After that you can click on the links and can export the files.

Hit the below link to see the page after you import these XMLs in your instance.

https://YOUR_SERVICENOW_INSTANCE.service-now.com/splitter.do

P.S: I made this for myself and that is why you wont see all the UI jazz, coding comments, etc.