- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2022 03:20 AM
How can I export a large table with more than 180000 records from ServiceNow to a Pdf, CSV, Exel file
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2022 06:07 AM - edited ‎12-08-2022 06:09 AM
There are OOTB system properties that limit the amount of data that can be exported. these are designed to protect the instance performance from large exports. These properties can be increased though as you require:
Under System Properties > Import Export you will see CSV, Excel, JSON and PDF export row limits. For Excel you also need to adjust the cell limit.
Be careful with this though as it may affect your instances performance and do it at a quiet time when few users will be using the instance e.g. out of normal working hours.
You may want to consider exporting in chunks to reduce this risk. See:
If this helps please mark as Helpful/Correct
Regards
Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2022 06:07 AM - edited ‎12-08-2022 06:09 AM
There are OOTB system properties that limit the amount of data that can be exported. these are designed to protect the instance performance from large exports. These properties can be increased though as you require:
Under System Properties > Import Export you will see CSV, Excel, JSON and PDF export row limits. For Excel you also need to adjust the cell limit.
Be careful with this though as it may affect your instances performance and do it at a quiet time when few users will be using the instance e.g. out of normal working hours.
You may want to consider exporting in chunks to reduce this risk. See:
If this helps please mark as Helpful/Correct
Regards
Paul
