Stale Report creation

[JA12]

Hi All, 

I'm looking for some assistance on how I can create a report to show all the assets that have been stale for 3 months. I created a report but doesn't seem right. I'm only looking for computers/ personal computer.

Or maybe on how to create a report on all the assets that Discovery wasn't able to touch.

[Ashok Sasidhara · Accepted solution]

Staleness is typically handled at the CI level. The 'Configuration item' reference field in asset tables indicates the CI corresponding to an asset. Similarly 'Asset' reference field in CMDB tables indicate the Asset corresponding to a CI.

You need to define the staleness criteria for the required CI classes like Computer class (cmdb_ci_computer) from CI class manager. Steps are mentioned in following URL:

https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/configuration-management/ta...

Then you need to make sure that CMDB health dashboard jobs are activated. 'CMDB Health Dashboard - Correctness Score Calculation' is the name of the job which covers staleness metric. Following URL has details of these jobs and how to activate them:

https://docs.servicenow.com/bundle/utah-servicenow-platform/page/product/configuration-management/ta...

Configuring staleness criteria and activating the jobs will populate the stale CIs data in the dashboard. In the following video, you can see how the various metrics including stale CIs are displayed in the CMDB health dashboard:

https://m.youtube.com/watch?v=aPHxWoVdD1c&pp=ygUqY21kYiBoZWFsdGggZGFzaGJvYXJkIHNlcnZpY2Vub3cgY29tbXV...