how can you include the sys_id in a report

Rob Litkenhaus · ‎02-13-2018

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 ?

darius_koohmare · ‎02-13-2018

1. Go to module System UI -> Lists

2. Select the record for the Table and view you want to modify (e.g. incident table, default view).

3. In the List Elements related list, add sys_id in the position you want

4. In your application navigator, type cache.do

View solution in original post

Rob Litkenhaus · ‎02-13-2018

Yes. I am exporting the data. I am working on an integration and a vendor is using an API to pull the sys_id as a unique identifier and they are telling me there are duplicate sys_id's and I don't think that is possible. I need to check the data for the sys_id value but can't seem to get it into a report or list view so I can see them all.

Patrick DeCarl1 · ‎02-13-2018

Robert,

In your URL you can add the following:

/hr_case_list.do?CSV&sysparm_default_export_fields=all

Just change out the table hr_case for whatever table you are looking at. This will auto download csv file with all the fields for table.

What Darius gave above does work in a list view but not in a report. Still seeing how to get it to work in a report.

Rob Litkenhaus · ‎02-14-2018

That's pretty cool that I can change the url and get all the data in a csv file directly. I did finally get the sys_id as a column in the list but whats odd is that if I change the url as you mentioned or even try to export the data as a csv or excel it gives me every column except the sys_id column even though I see it in my view. Only when I select export as xml do I get the sys_id column and that format is not very friendly to use.

Michael Ritchie · ‎02-14-2018

I just tried logged in as an Admin and an end user (no roles) and was able to get all the incidents including the SysID with this URL:

https://INSTANCE-NAME.service-now.com/incident_list.do?EXCEL&sysparm_default_export_fields=all

Since the columns are exported in alphabetical order SysID will be towards the end but not at the very end.

darius_koohmare · ‎02-13-2018

sysID is a primary key in the database, there would be a unique key violation if it was duplicated.

In any case, another method is to:

Right click the computer list view header (or press the three line context menu) and select "Import"

Change it to "Update", and download the Excel template.

This will include all sysIds.