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 ?

[darius_koohmare · Accepted solution]

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

[Rob Litkenhaus]

That did not work. I added the sys_id to every view and still cannot see it. I'm trying to add it to the cmdb_ci_computer table. Any other suggestions ?

[abhishekdash]

Hello Robert,

Can you follow the below step after what Darius has suggested:

a) Open the list view for 'cmdb_ci_computer'

b) Click on the gear icon on the list header(Personalize List Columns)

c) There will be a button on the left side named 'Reset to column defaults':

d) Now clear the cache (cache.do) and reload the page. (better to logout and relogin)

This should bring the column.

Hope this helps.

If this reply assisted you, please consider marking it Correct, Helpful, or Like it.

This helps other customers to learn from your thread.

Thanks,

Abhishek

[Patrick DeCarl1]

Why do you need the sys_id within a report? Are you exporting this data?