Report of Changes in CI Records

cdi · ‎04-03-2017

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 · ‎04-04-2017

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

View solution in original post

Teena Singh · ‎04-05-2017

Tim,

Glad to see that you are using the Community to learn more.

The Customer Experience team is striving to ensure that customer queries posted from the HI Service Portal are answered in timely and accurate fashion.

If you feel your question has been resolved, please mark the appropriate reply in the thread as being the Correct Answer.

This enables other customers to learn from your thread.

Thank you in advance.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View.

Regards,

Teena Singh
Customer Experience: UX Strategy and Customer Insights
teena.singh@servicenow.com

ServiceNow

Screen Shot 2017-01-19 at 8.55.52 AM.png

Dave Smith1 · ‎04-05-2017

Have you looked at the Configuration Dashboard? It seems to be exactly the sort of thing you're after...

Robbie · ‎04-06-2017

Hi Tim,

How did you go?

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

Thanks,

Robbie