Scoring in New CMDB Health Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-30-2024 02:52 PM - edited ‎10-30-2024 03:00 PM
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:
- 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.
- 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, namedlinux_server_0
tolinux_server_13
, each with a corresponding CPU count from 0 to 13. - I added a new orphan rule for Linux servers where cpu_count > 9 and ran the correctness job.
- 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.
- I then created 4 duplicate CIs,
linux_server_0
tolinux_server_3
, and ran the correctness job once more. Updated 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).
Health inclusion rules will also play a role in computing the total CIs for the KPI Metrics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-13-2024 12:11 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-14-2024 07:00 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-16-2024 10:11 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-17-2024 10:13 AM
We are aware of an issue on this and there should be a defect provided to you on this.