Breaking up large files due to export limit

Tanisha Hudson
ServiceNow Employee
ServiceNow Employee

I wish to export some data from an instance. The data that I search for returns about 13,000 rows. The .csv threshold limit is only 10,001. How could I extract all the data in chunks? I followed the tutorial, but do not have a solution as this is not working for me.

 

 

This is my output when I filter:

find_real_file.png

 

 

This is the url from that output:

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML

 

This returns 13,169 rows.

According to the documentation, I can do this:

 

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

 

This is what I have done, I have included

 

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 

I have added: &sysparm_orderby=sys_id&sysparm_record_count=10000 to the end of my url, and hit enter. The  output remains the same.

 

Any suggestion is appreciated

 

 

 

6 REPLIES 6

Thank you, I was advised not to increase the limit.

How could I solve this without increasing limit please?

This is what I am doing to break this into chunks:

 

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 

SNUG AM
Giga Guru

%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 change to

%3FXML&sysparm_orderby=sys_id&sysparm_record_count=10000