---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Break up a large export

# Break up a large export {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

If the number of records to be exported exceeds the actual export limit, you may want
to break the export into smaller increments that do not place a significant performance load
on the platform.

## Before you begin

Role required: none

## Procedure

1. Create a filtered list of records that you want to export by following the steps in [Export directly from a URL](https://servicenow-prod.fluidtopics.net/r33hJs80JRI0fmDtvQYHOw "Dynamically export data from a script or web service by building a URL query.").
2. Write down the number of records returned.
3. If the record number is higher than the defined threshold, issue a sysparm query for the first 10,000 records using the following syntax:  

       https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_orderby=sys_id&sysparm_record_count=10000

   This exports the first 10,000 records in order, sorted by the
   sys_id number.
4. Find the next record in order, such as 10,001.  
   You can find the next Sys ID value by creating a database view on the table and adding the sys_id column to the view. You don't need to specify a where clause. After you create the database view, view the records and their Sys ID values by selecting Try it. You can sort by the sys_id column and enter 10,001 to skip to that row.
5. Right-click the row and copy the sys_id of the next record you want to export.
6. Access the next series of records with a greater than or equal to query run against the sys_id of record 10,001.  
   The following example shows a query that uses a sys_id of
   b4aedb520a0a0b1001af10e278657d27. Use the syntax shown in this query to
   export the next set of records.

       https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_query=sys_id%3E%3Db4aedb520a0a0b1001af10e278657d27&sysparm_orderby=sys_id&sysparm_record_count=10000

   Note:  
   URL queries use typical percent encoding. In this example, the greater than sign (\>) is encoded as %3E and the equal sign (=) is encoded as %3D.
7. **Optional:** Continue issuing this query, using the starting sys_id for the next set of records until you have exported all the necessary records.