How to export filtered list view with all fields including sys_id to EXCEL

[Lukasz S1]

To export data we need to build url

1) Just use Filter menu to Copy URL

- example URL 

https://devxxx.service-now.com/cmdb_ci_list.do?sysparm_query=manufacturer%3Daa0a6df8c611227601cd2ed45989e0ac&sysparm_view=

2) Modify URL with export parameters:

https://devxxx.service-now.com/cmdb_ci_list.do?EXCEL&sysparm_query=manufacturer%3Daa0a6df8c611227601cd2ed45989e0ac&sysparm_view=&sysparm_default_export_fields=all

Done

Just keep in mind that typically there are properties in ServiceNow which don't allow to export for example more than 10 000 records.

[Adam Stout]

The documentation should walk you through this with the various options and setting that effect exporting:

https://docs.servicenow.com/csh?version=latest&topicname=t_ExportDirectlyFromTheURL

[GG-Amitola]

Thanks for the great tip, worked a treat