Export List of Records into CSV with SysID

[salvadormarchan]

Hello All,

I really need help on the scenario that one of Managers is asking me. They wanted to export CSV files from a List of Records including the SysID (32 long string ID). I can find it individually but not as part of a list.

Please advise how to do this.

Thank you in advance.

Dor Marchan
one month-old newbie admin

[Blaze2]

Try this wiki article to see if you are able to get your records

Exporting Data - ServiceNow Wiki

[servicenowsnow]

Thank you for feedback , i have tried with below link to export data.

https://myinstanceservice-now.com/cmdb_ci_server.do?CSV&sysparm_order_by=sys_id

we cant see any sys ID in exported data.

[xiaix]

This too is brilliant!   Thanks!

[Paul Ciarfella]

The way that I have solved this problem is to have a shadow copy of the sys-id field in the record.     For example, we wanted a unique identifier on CI's which can have name changes, and users can lose track of the CI in their reports.     The field is called Application UID (32 char string) and is set on insert to the value of the sysid.     Its reportable but does not show on the form or list view.

[paulramsey]

I know this is an old post, but it still shows up first on some Google searches, so I'm leaving this for posterity.

This topic is covered on the ServiceNow Developer site now. Check out the blog post below:

https://developer.servicenow.com/blog.do?p=/post/exporting-data-with-sys-ids/