CMDB Health KPIs and metrics

Extend Now Platform capabilities > Configuration Management Database (CMDB) > <a class="link" href="../../../product/configuration-management/concept/c_ITILConfigurationManagement.html" title="With the ServiceNow Configuration Management Database (CMDB) application, build logical representations of assets, services, and the relationships between them that comprise the infrastructure of your organization. Details about these components are stored in the CMDB which you can use to monitor the infrastructure, helping ensure integrity, stability, and continuous service operation.">Manage the CMDB >

The overall CMDB health score consists of three Key Performance Indicators (KPIs) which are correctness, compliance, and completeness, each further consisting of sub-metrics. Each KPI and metric is associated with a scorecard that determines its contribution to the aggregated health at the overall CMDB level, class, and CI level.

You can configure which KPIs and metrics are included in the aggregated calculation, and set their weight in the aggregation. In the base system, all KPIs and all metrics are included in the aggregated health report.

Overall An aggregation of all three KPIs (correctness, completeness and compliance), according to their overall scorecard weight settings.

Correctness A KPI which is an aggregation of the following metrics, according to the correctness scorecard weight settings.

Orphan

Measures the percentage of orphan CIs in the CMDB. A CI can become orphan if it was unintentionally left in the CMDB when it is no longer needed. A CI is determined to be orphan if: The CI satisfies the criteria in an orphan rule . This criteria checks for specific attributes that a CI must have, and for CIs that have no relationships or that don't have specific relationships. Data is missing for the CI in its respective table, or in one of its parents' table.

Staleness

Measures the percentage of stale CIs in the CMDB. A CI is stale if it was not updated within the Effective Duration time period that is specified in the staleness rule that applies to the class.

The base system includes a default staleness rule for the Configuration Item [cmdb_ci] class, which sets the Effective Duration time to 60 days. This rule applies to all extended CMDB classes, and can be overridden by class specific staleness rules defined by the user. To determine CI staleness, a staleness rule for the CI's class is used if it exists, otherwise, the default staleness rule is used.

In addition, a relationship in which a stale CI is a parent or a child, is determined to be a stale relationship.

Note: Discovery marks VMware vCenter CIs that no longer physically exist, as stale. By default, this setting takes precedence over a CMDB Health staleness rule defined for the CI. When drilling-down in the CMDB dashboard to Health Results, the Source for CIs determined to be stale by Discovery, is CLOUD_DISCOVERY . Setting the glide.cmdb.health.src.cmdb_health_audit_only system property to true, ensures that the CMDB dashboard displays health results generated only by CMDB Health. For more information, see CMDB Health system properties and Discovery for VMware vCenter .

Duplicate

Measures the percentage of duplicate CIs in the CMDB using identification rules . Only independent CIs are evaluated for duplication. In a set of duplicate CIs, the count of duplicate CIs is the total number of CIs in the set, minus one. The detailed graphs for a duplicate set of CIs display all the CIs in the set.

For more details, examples, and troubleshooting information about duplicate metric, see the CMDB Health - Duplicate Metric - algorithm [KB0726425] knowledge base article.

Completeness A KPI which is an aggregation of the following metrics, according to the completeness scorecard weight settings.

Required

M easures the percentage of CIs in which fields that are defined as mandatory, are not populated. Missing fields are tagged as incomplete noting that for this CI some information is missing. Required fields are equivalent to the fields that are specified as mandatory in the system dictionary.

Recommended

Measures the percentage of CIs in which fields that are set as recommended , are not populated. Out-of-box, no recommended fields are specified.

You can use the Add Identifier Fields In Recommended Rules scheduled job to set criterion attributes from active identification rules, as recommended fields. You can use the Remove Identifier Fields In Recommended Rules scheduled job to unset criterion attributes from active identification rules, as recommended fields.

Compliance Based on the results of actual CMDB audit runs.

Audit

Audit compares actual values of specified fields, against expected values defined in template and scripted audits. Based on the Last run date of audits, CMDB Health identifies the set of the most recent complete audit run, and uses those audit results. To pass the CMDB Health audit test, a CI must be in compliance with all audits for that CI. Create a compliance-type audit, for which the results are calculated into the CMDB Health compliance KPI.

When running scripted audits , the Last run date is not populated. Therefore, for the compliance KPI to include the results of a scripted audit, update the script in the audit to record the audit run time.

Relationships Measures the health of CI relationships, consisting of the following metrics which are not-configurable:

Duplicate relationships

R elationships that have identical parent and child CIs, identical relationship type, and an identical port. Duplicate relationships are displayed per relationship type. In a set of duplicate relationships, the duplicate relationship count is the total number of duplicate relationships in the set, minus one. The detailed graphs for a duplicate set of relationships display all the relationships in the set.

Orphan relationships

A relationship that is missing either a parent CI, a child CI, or both.

Stale relationships

A relationship in which the parent CI or the child CI is a stale CI.

A single relationship can fail more than one health test. For example, a duplicate relationship can also be stale.

Also reports the following relationship-related summaries: Relations not compliant with suggested relations Relations not compliant with containment rules Relations not compliant with hosting rules

Parent Topic: CMDB Health

Related concepts <a class="link" href="../../../product/configuration-management/concept/cmdb-health-domain-separation.html" title="This is an overview of domain separation as it pertains to CMDB Health. Domain separation enables you to separate data, processes, and administrative tasks into logical groupings called domains. You can control several aspects of this separation, including which users can see and access data.">Domain separation in CMDB Health CMDB Health dashboards View CMDB health reports <a class="link" href="../../../product/configuration-management/concept/monitor-service-health.html" title="The CMDB service dashboard serves as a central location to view aggregated health reports for services at a glance. Also, it lets you drill into a service to perform remediation actions that address health issues, and that improve CMDB health. The CMDB service dashboard uses the Performance Analytics framework for dashboards and employs the capabilities it provides.">View services health reports <a class="link" href="../../../product/configuration-management/concept/monitor-cmdb-group-health.html" title="The CMDB group view dashboard serves as a central location to view aggregated health reports for CMDB groups at a glance. Also, it lets you drill into a CMDB group to perform remediation actions that address health issues, and that improve CMDB health. The CMDB group view dashboard uses the Performance Analytics framework for dashboards and employs the capabilities it provides.">View CMDB groups health reports

Related tasks <a class="link" href="../../../product/configuration-management/task/t_ViewCIHealth.html" title="The CI dashboard is a central location displaying health report for an individual CI, history of changes to the CI in a timeline view, and the relation formatter. The CI dashboard also displays incidents, changes, and other tasks affecting the CI, and business services affected by the CI. You can access the CI dashboard from a CI form, or from the CMDB dashboard.">View CI health View CI relationships health Create CMDB remediation rule <a class="link" href="../task/t_ConfigureCMDBHealthMetrics.html" title="Metrics health scorecards are aggregated into their respective KPI, which in return are aggregated into the overall CMDB Health report. Set aggregation preferences for KPIs, and for each of their respective metrics, deactivate KPIs and metrics that you are not interested in reporting, and adjust weighted averages of aggregation.">Configure KPI and metrics aggregation preferences Configure CMDB Health scorecard thresholds

Related reference CMDB Health process tracking CMDB Health system properties