how can you include the sys_id in a report

[Rob Litkenhaus]

How can you include the sys_id in a report and how can you view the sys_id in a list view or on the actual records as a value in a field ?

[Rob Litkenhaus]

This worked, Thanks. I was able to select import and select Update and create Excel template. That gave me the sys_id. I will be able to use this to prove that the sys_id is unique.

There are other reason that sometime I need to capture the sys_id in a report. I wish there was an easier way to be able to select this field when creating a report on any table. What you provided works if you are an admin but you don't have the import option as a regular user and for production I don't have admin.

Maybe it needs to be an ServiceNow enhancement request.  

Thanks again.

[Michael Ritchie]

Another work around I have used before the sysparm_default_export_fields=all property was added was to create a database view for your table.   Call it TableName (change) Export and then in your view tables, just include your one table and nothing else.   Then when you create a report against your view table, SysID is available to select.   Yes definitely a hack, but it works.  

[Andrew Bettcher]

Again with the genius mate. This will solve my issues discussed on the other forum post where you helped me. I was trying to get a transform to pick the right asset record where they are legitimately duplicated due to contract administration issues. Obvs, sys_id will ALWAYS be completely unique and as the source in this case comes from ServiceNow, I can make use of it. 

Cheers mate.

[Community Alums]

Hello Pat,
Seeing this thread as I have same question - how to add sys_id on a report?
On my case, exactly what you said, I'm exporting data.

Any help will be appreciated.
Thank you in advance.

[meganp]

Hi Rob,

Here is a KB article that might be helpful-

https://hi.service-now.com/kb_view.do?sysparm_article=KB0690876

It's important to note, that even if you add the sys_id field to a table, in the Istanbul release reports do not display that field. Starting in Jakarta and later, the sys_id became visible from reports.

Thank you,

Megan