Exporting Large Data Sets?

[Chris M3]

We have some teams that need the ability to export larger datasets, > 50,000 rows, for auditng and licensing purposes.   I know that they can manually break up the exports into chunks, and export each chunk, but we're trying to come up with an easier way for this to be accomplished.   Has anyone developed something like this?

[Michael Kaufman]

You can change the export limits.   http://wiki.servicenow.com/index.php?title=Exporting_Data#Export_Limit_Properties

The default 50,000 row limit isn't enough for many companies.   150,000 is more reasonable in cases.

[Chris M3]

I changed the glide.csv.export.limit property to 200,000.   Exporting to CSV still resulted in only 50,000 records returned.   Is there something else that has to be done?

This is on our Calgary instance

[Michael Kaufman · Accepted solution]

Try setting these parameters:

glide.ui.export.limit | 200000

glide.pdf.max_rows | 200000

glide.csv.export.limit | 200000

glide.excel.export.limit | 200000

Logout/back in and clear your cache <yourinstance>.service-now.com/cache.do after setting the parameters.   Maybe the limit is cached.

If that doesn't work, try this parameter:

glide.excel.max_cells | 1000000