Sys_id not showing for list view of Sys_report

[StacyWhetzell]

I need to create a list view of all our reports.  Since Report Name is not unique, I need the Sys_ID

I've tried every which way but loose to locate and expose sys_id in the list view of sys_report or in report_stats.

I am admin, but cannot see the field except by opening a report and then copy sys_id or show XML

Any help appreciated

Stacy Len

[lauri457 · Accepted solution]

List layouts can be configured from the table [sys_ui_list]. A record with a non empty user field is someone's personalized layout, empty user field corresponds to the default layout for the corresponding view. 

In the list record that matches your table sys_report/report_stats and view add a List Element [sys_ui_list_element] from the related list with element "sys_id".

If you have the snutils extension you can just double click the personalize layout modal with the slushbucket and it will let you add the sys_id field for your personalized layout.

[lauri457 · Accepted solution]

List layouts can be configured from the table [sys_ui_list]. A record with a non empty user field is someone's personalized layout, empty user field corresponds to the default layout for the corresponding view. 

In the list record that matches your table sys_report/report_stats and view add a List Element [sys_ui_list_element] from the related list with element "sys_id".

If you have the snutils extension you can just double click the personalize layout modal with the slushbucket and it will let you add the sys_id field for your personalized layout.

[Tanushree Maiti]

Hi @StacyWhetzell 

You can check step by step instruction with screen shot  in following article:

Add sys_id column to List View

[Dr Atul G- LNG]

By design, the Sys ID field is not easily available for users to display on forms, lists, nor reports. This is because this field contains a unique numerical identifier for each record. If the Sys ID is modified or deleted, this would lead to bad data and/or data loss

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0690876

[KumkumM · Accepted solution]

Hi Stacy,

You won’t be able to find the sys_id field while configuring the List Layout, as it’s a system field and is hidden by default in ServiceNow.

However, you can make it visible in the list view by following these steps:

1. Navigate to System UI → Lists

2. Open the list configuration for the Report [sys_report] table

3. Add a new field element as sys_id and set its desired position

4. Save the configuration

Now you should be able to see the sys_id in the list view.