Report of Changes in CI Records

[cdi]

We are looking for a better way to generate a report of changes to CI records.  We tried creating a database view using the cmdb_ci and sys_audit tables and creating the report using the database view as the table.  This works, but the sys_audit table is too big of a table to do this against so it affects overall performance.  Is there a better way of doing this?

[Robbie · Accepted solution]

Hi Tim,

Have you explored the functionality provided by the CDMB Baseline feature? (Wiki link: http://wiki.servicenow.com/index.php?title=Baseline_CMDB#gsc.tab=0)

The baseline essentially creates a snapshot of configuration items (configurable by type or class etc), which allows you to review all the changes made to that ci.

Whilst I'm not sure its possible to directly report off of this table in the general reporting sense, the view provided by the Baseline displays all the data thats has been changed/updated that CI management would require. Notifications etc can also be based to help you track these.

Please mark this response as correct and helpful via your post link (Report of Changes in CI Records ) to help others with the same question.

Thanks,

Robbie

[marcguy]

Hi Tim,

I wrote this blog post a few years back but think it all still works and applies to your scenario?

Reporting on CI Changes - Using History Sets

[cdi]

I am waiting to hear back from the client's ServiceNow System Administrator to see if this works for them.   Thank you!

[Sam Phillippi]

I am trying to implement this in Jakarta, but it is pulling changes made to Change Records, Stories, Ideas, etc. but not CIs. Does this not work in Jakarta by chance?