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 designed for CMDB administrators to monitor and improve data quality within the Configuration Management Database (CMDB). It provides targeted metrics and actionable insights for principal CI classes, helping to identify data quality issues such as incomplete attributes, stale records, and duplicates. This enables organizations to maintain accurate and reliable CMDB data, which is critical for effective IT service management.
Show less
Access and Requirements
- The dashboard is accessible via the CMDB success advisor landing page by selecting "View insights for Data Foundations".
- It requires completion of the CMDB success advisor for Data Foundations setup process.
- The user must have the sncmdbadmin role to access the dashboard.
Use Cases for ServiceNow Customers
- Monitor completeness of CI attributes across principal classes.
- Identify CI classes at risk due to low data quality scores.
- Detect stale and duplicate CI records affecting CMDB accuracy.
- Evaluate integration source coverage to ensure proper CMDB population.
- Prioritize remediation efforts based on impacts to incidents, changes, and problems.
- Track progress toward Common Service Data Model (CSDM) alignment.
Dashboard Features and Practical Use
The dashboard consolidates key CMDB data quality metrics into interactive charts and filters, allowing administrators to:
- View operational CIs by principal class and data integration source to understand distribution and source contributions.
- Identify CIs missing critical attributes like name, managed by group, or location, which impact data completeness.
- Detect data quality issues such as stale CIs not updated within defined maintenance windows and duplicate CIs causing redundancy.
- Filter data dynamically by principal classes, date ranges, and stale CI thresholds (7, 14, 30, 60, 90 days) to focus analysis.
- Access KPI Details pages for trend analysis and remediation action panels to guide corrective steps and improve data quality over time.
Important Notes for Customers
- Dashboard data is influenced by the selected filters, so adjusting the principal class and date range filters tailors insights to specific needs.
- Performance Analytics data collector row limits may prevent some metrics from loading; a notification banner will appear if this occurs.
- Remediation actions available on KPI Details pages provide structured guidance to resolve identified data issues efficiently.
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 |