Is there a way to display sys_id for Configuration Items in reports?

[Bob D]

I am trying to create an export of data from cmdb_ci_computer table that includes the sys_id value for each record and is also filtered for Status=Installed.  Plus, I want to schedule this export/report to run automatically.  I'm stuck on getting the sys_id.   If I look at the table definition for cmdb_ci_computer I can see the sys_id field is available there.  But when I create a report on the Computer table, sys_id is not one of the available column choices.   How can I make this field/column available?

I've seen suggestions to use a Database View or even construct a URL that will pull the value, but these two solutions don't seem to support my other requirements stated above.

[amaradiswamy · Accepted solution]

Hi,

Refer to below.

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

https://community.servicenow.com/community?id=community_question&sys_id=a308c36ddb1cdbc01dcaf3231f96...

[amaradiswamy]

Hi,

Are you still looking for an answer? Otherwise, mark a reply as correct so that others looking for same may get benefited.

[Bob D]

amaradiswamy provided links to some very helpful information and possible solutions to my question.  The solution I have decided to implement is to use a scheduled export set.  This allows me to include sys_id in the output, filter the output to the fields/columns I need, filter the output conditionally based on the value(s) of specific field(s), and also schedule the export to run automatically.  As an added bonus, an export set allows me to drop the data onto a MID server inside my network rather than delivery by email.  So in all - this meets all my requirements.