Monitoring CMDB data quality using dashboard metrics in CMDB success advisor for Data Foundations
Summarize
Summary of Monitoring CMDB data quality using dashboard metrics in CMDB success advisor for Data Foundations
The CMDB success advisor for Data Foundations dashboard is a tool designed for CMDB administrators to monitor and improve data quality within the Configuration Management Database (CMDB). It focuses on principal configuration item (CI) classes, providing insights into data completeness, accuracy, and integration coverage. This dashboard helps identify data quality issues such as missing attributes, stale records, and duplicates, enabling targeted remediation to maintain CMDB reliability.
Show less
Key Features
- CI Distribution by Principal Class: Visualizes the breakdown of operational CIs by principal classes to understand CI distribution in the CMDB.
- Integration Source Tracking: Displays how different data integration sources contribute to populating the CMDB.
- Attribute Completeness Metrics: Highlights CIs missing key attributes like name, managed by group, or location, to identify data gaps.
- Data Quality Issue Metrics: Identifies stale CIs (not updated within a defined timeframe) and duplicate CIs that affect accuracy and process reliability.
- Filters: Enables filtering data by principal classes, date ranges, and stale CI thresholds (7, 14, 30, 60, 90 days) to focus analysis and remediation efforts.
- Interactive KPI Details: Selecting chart segments opens detailed KPI trend pages and, if available, remediation action panels to guide data quality improvements.
Practical Use and Benefits for ServiceNow Customers
- Monitor Attribute Completeness: Quickly identify which CI classes lack critical attribute data, improving the overall quality and usability of CMDB records.
- Detect and Address Stale and Duplicate CIs: Recognize outdated or redundant records that can impact incident, change, and problem management accuracy, enabling focused cleanup.
- Evaluate Integration Coverage: Ensure the right data sources are feeding the CMDB to maintain comprehensive and accurate configuration data.
- Prioritize Remediation Efforts: Use impact metrics related to incidents, changes, and problems to focus on the most critical data quality issues first.
- Track Progress Towards CSDM Alignment: Support ongoing CMDB maturity and compliance with the Common Service Data Model (CSDM) through continuous data quality monitoring.
Access and Requirements
- The dashboard is accessible from the CMDB success advisor landing page via the “View insights for Data Foundations” option.
- Access requires the sncmdbadmin role.
- The dashboard is available only after completing the CMDB success advisor for Data Foundations setup process.
- A notification appears if Performance Analytics data collection exceeds limits, potentially impacting metric availability.
The CMDB success advisor for Data Foundations dashboard enables CMDB administrators to identify and address data quality issues specific to principal classes in the Configuration Management Database (CMDB).
Access the dashboard
To open the dashboard, select View insights for Data Foundations on the CMDB success advisor landing page. See Access CMDB success advisor.
Required roles
| Role | Description |
|---|---|
| sn_cmdb_admin | Required to access the Data Foundations dashboard. |
Use cases
For examples of how different people in your organization would use this dashboard, see these use cases.
| User | Dashboard use |
|---|---|
| CMDB administrator |
|
Dashboard features
The dashboard provides clear, consolidated insights into principal CI class data quality and completeness. Use the dashboard to identify and resolve data quality issues within the CMDB through dedicated sections, filters, indicators, and visual reports. Gain valuable insights into CMDB performance related to Data Foundations. Targeted CMDB metrics focus remediation efforts. Regularly monitor these metrics and follow suggested remediation actions to systematically improve CMDB data quality over time.
| Feature | Description |
|---|---|
| CIs by principal class | Displays the breakdown of operational CIs by principal CI class to highlight CI distribution in the CMDB. |
| CIs by data integration source | Displays the breakdown of operational CIs by data integration source to highlight their contribution to CMDB population. |
| CIs missing key attributes | Displays completeness metrics per principal CI class, identifying classes below the defined threshold. |
| CI data quality issues | Displays key metrics related to CIs that have not been updated or may have duplicate records, leading to outdated information and inconsistencies in the CMDB. |
Filters
Enables narrowing the data shown in graphs and metrics based on principal class, date range, or stale CI threshold.
| Name | Type | Description |
|---|---|---|
| Principal classes | List | Filters CIs based on the selected principal classes. |
| Date range | Date | Filters the dashboard data based on the selected date range. |
| Stale CI | List | Filters stale CIs based on the number of days since their last update. Available values: 7, 14, 30, 60, and 90 days. |
CIs missing key attributes
Key metrics for the completeness of CI attributes across principal classes, identifying gaps that affect data quality.
| Card | Description | Indicators |
|---|---|---|
| CIs missing name | Total number of CI records from principal classes missing a name, measured daily, where the CI does not have a name specified. | DF CIs missing name |
| CIs missing managed by group | Total number of CI records from principal classes missing a managed by group, measured daily, where the CI does not have a managed by group assigned. | DF CIs missing managed by group |
| CIs missing location | Total number of CI records from principal classes missing a location, measured daily, where the CI does not have a location assigned. | DF CIs missing location |
CI data quality issues
Key metrics for CIs that have not been updated or may have duplicate records, leading to outdated information and inconsistencies in the CMDB.
| Card | Description | Indicators |
|---|---|---|
| Stale CIs | Principal class CIs not updated within the expected maintenance window, causing data gaps and inaccuracies that affect incident and change impact analysis. Additionally filtered by the Stale CI filter. When you select a segment on the Stale CIs chart, the KPI Details page title reflects the Stale CI filter value selected at the time (for example, "CIs not updated in last 30 days"). |
DF CIs not updated in last 7 days DF CIs not updated in last 14 days DF CIs not updated in last 30 days DF CIs not updated in last 60 days DF CIs not updated in last 90 days Note: The CIs not updated card data is additionally filtered based on the Stale CI filter. See Filters. |
| Duplicate CIs | Operational CIs identified as duplicates within principal classes, causing ambiguous CI selection in processes and data redundancy. | DF duplicate CIs |