I want to extract more than 3 million records created for a catalog item

MohammedYaseen · ‎02-20-2024

Hi Team,

How to extract more than 3 million records created for a catalog item.

Will extracting cause any slowness in Servicenow

Thanks

shloke04 · ‎02-20-2024

I will not recommend increasing the export limit to extract 3 million data from ServiceNow table as it will impact platform performance health. If still you want to go down that route below doc link gives detailed steps on how export limit can be managed:

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/exporting-da...

Couple of recommended options I would suggest here:

1. You can break your export into smaller data set and follow the detailed steps mentioned in ServiceNow docs:

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/exporting-da...

2. You can make use of the solution mentioned in the article below:

https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

3. Another approach can be similar to what's mentioned in step 1 is to make use of Rest Web Services which does the manual work for you through REST API. Detailed steps are called out in below HI article:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

shloke04 · ‎02-25-2024

Hi @MohammedYaseen - If your query is resolved then do mark the answer as correct and close this thread.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke