Scoring in New CMDB Health Dashboard

Sandeep90
ServiceNow Employee
ServiceNow Employee

The CMDB Health Dashboard has been redesigned in Xanadu and moved to the CMDB Workspace, enabling ServiceNow to iterate more rapidly and improve the dashboard. In this article, I'll explain the new scoring system with an example dataset.

Key changes to the health dashboard include:

  1. Simplified scoring: The previous threshold settings for calculating KPI scores (completeness, correctness, compliance) have been removed. The KPI score is now calculated as the ratio of all failed CIs across sub-metrics to the total CIs across those sub-metrics.
  2. Failure limits: The maximum failures for each metric (e.g., Required, Recommended) are now capped at 100K, regardless of the failure threshold setting in Health Preferences.

 

Below is an overview of how scores are calculated for each KPI (Correctness, Completeness, Compliance).

 

  • I added 14 Linux server CIs to the cmdb_ci table, named linux_server_0 to linux_server_13, each with a corresponding CPU count from 0 to 13.
    Sandeep90_0-1730324521757.png
  • I added a new orphan rule for Linux servers where cpu_count > 9 and ran the correctness job.Sandeep90_1-1730324556780.png
  • As a result, 4 CIs failed the orphan rule, while 10 were healthy, resulting in a 71% (10/14) health score for the orphan KPI.  For correctness: Across all three metrics, 4 out of 14 CIs failed, yielding the same 71% score.Sandeep90_2-1730324590477.png
  • I then created 4 duplicate CIs, linux_server_0 to linux_server_3, and ran the correctness job once more.
  • Sandeep90_3-1730324742123.pngUpdated scores:

                  Duplicate: 8 failures for CIs ending in 0-3; score: 10 healthy out of 18 total, or 56%.

                  Orphan: 4 failures for CIs ending in 10-13; score: 14/18, or 78%.

                  Correctness: 12 total failures (8 from CIs ending in 0-3 and 4 from those ending in 10-13), resulting in a 33%                                          score (6 healthy out of 18).

Sandeep90_4-1730324765624.png

 

 

Health inclusion rules will also play a role in computing the total CIs for the KPI Metrics 

 

4 REPLIES 4

MOdijk
Tera Contributor

Since the upgrade from Vancouver to Xanadu (patch 3) the scheduled jobs that calculate the audit results take forever, effectively eating up all the workers. Does anyone else experience this issue?

Sandeep90
ServiceNow Employee
ServiceNow Employee

@MOdijk Can you be more specific is the compliance job that is causing the issue or is it the desired state audit taking time and occupying workers ? Please open a support ticket to help you resolve this issue. 

MOdijk
Tera Contributor

Hello Sandeep, I opened a support ticket back then (still open, but work is ongoing). It is indeed about the Compliance jobS that are created for the audit rules.

Sandeep90
ServiceNow Employee
ServiceNow Employee

We are aware of an issue on this and there should be a defect provided to you on this.