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?

[ms_akila]

Thank you slava...if i use views for taking the report will create a table ...i dont want to create any new table while creating the views..In snow view will not create virtual table ...is there any function like https://myinstance.service-now.com/incident.do?CSV&sysparm_default_export_fields=sys_id to take repo...

[Slava Savitsky]

How about this tip by jim.coyne ?

Re: Need to be sys_id in export files

[ms_akila]

Hi,

Adding the sys_id in default list layout will be visible even to itil users.

i would suggest to go with database view.

Create a dabase view and add the required table.

Then select the fields along with sysID's which you want to pull the report.

save it and try it.

Regards,

Akiladevi R

[Geoffrey_Bishop]

So @ms.akila , if a Database View is used, then it will NOT be visible to ITIL users?

Who WILL it be visible to?  Please explain.  Thx.

[Valor1]

You can think of a DB View as a virtual table -- complete with ACL controls. In order to grant access to the view, create a module and a "read" ACL for the view table.

It's typically used for things where you have indirect references. One OOB example is for "incident_metric" where you need to join metric instances to definitions to incidents -- all indirect relationships. 

When you click the "Try it" related link, you see a typical list view, and when you configure the columns, you'll see a full list of all columns across all 3 tables.