SYS_ID column in list view

[Valor1]

Long time listener, first time caller..

I cannot for the life of me determine how to get the "Sys ID" field to show up in a list / list filter. Some instances show the field and some do not. I've searched the wiki, community and our internal resources and can't find it.

Is there a property or user preference that I'm missing?

[Geoffrey_Bishop · Accepted solution]

For adding the sys_id column to a List View, this article includes screenshots and step by step instructions, and may help someone.

Add sys_id column to List View

[haldroid]

Thanks for posting. I'm about to deal with this again. Seems to be a long-standing request & community here has quite a few prior postings with good ideas. Ones that look promising to me are:

• Mark Stanger's posting at Easy way to create a List report and include the sys_id
• John Anderson's posting at Export data to CSV including sys_id field (has links to JSON and JSONv2 processors)

P.S.: Just saw Mark Amann's reply. Thank you Mark!

[Slava Savitsky]

One can also get the sys_ids included in an export by using "sysparm_default_export_fields=all" URL parameter as explained here:

Exporting Data - ServiceNow Wiki

[ms_akila]

I dont want all default fields while taking report ..i want only theimportant field like number,state,description,assignment group,assigned to with the sys_id. Is it possible to take the report ?

[Slava Savitsky]

It seems a Database View can help you work around the limitation as explained here:

Re: Need to be sys_id in export files