Large Exports from ServiceNow
Summary
As ServiceNow points out in KB0727636, by default, ServiceNow has a max limit of 10,000 records that can be exported from a table when using the user interface, the Table API or the Export URL method, i.e. https://instancename.service-now.com/cmdb_ci_computer.do?CSV&sysparmdefaultexportfields=all
Solution
A simple PowerShell script that will query the Table API for the selected table and loop through blocks of 10,000 until all records are retrieved. It then converts the JSON payload to a CSV.
Leave a comment