Monitoring CMDB data quality using dashboard metrics in CMDB success advisor for HAM

The CMDB success advisor for HAM dashboard enables CMDB administrators to identify and address data quality issues specific to HAM in the Configuration Management Database (CMDB).

Important :

When you select a segment or count on a chart from a CMDB success advisor dashboard, the KPI Details page opens. On the page, you can analyze how a specific metric trends over time. Additionally, the Remediation actions panel appears when remediation actions are available for that card. Use the panel to improve the quality of CMDB. To learn more, see KPI Details and Improving CMDB data quality for HAM.

Access the dashboard

To open the dashboard, select View insights for HAM on the CMDB success advisor landing page. See Viewing the CMDB success advisor landing page.

Remarque :

The CMDB success advisor for HAM dashboard is available only after the setup process is complete. For more information, see Set up CMDB success advisor for HAM.

Required roles

Tableau 1. Roles required for CMDB success advisor for HAM dashboard

Role	Description
sn_cmdb_admin	Required to access the dashboard.
pa_viewer	Required to filter data by model categories.
pa_data_collector	Required to view the last updated data timestamp on the 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	Gain real-time visibility into hardware asset data quality and completeness Identify missing or incorrect CI attributes quickly Detect duplicate CIs and unlinked assets Monitor asset life cycle status (installed, retired, inactive) Prioritize and track data cleanup and remediation tasks Verify that the CMDB stays accurate to support HAM

Dashboard features

The dashboard provides clear, consolidated insights into hardware asset data quality and asset status. 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 HAM.

Targeted CMDB metrics focus remediation efforts. Regularly monitor these metrics and follow suggested remediation actions to systematically improve CMDB data quality over time.

Important :

The dashboard data is filtered based on the Selected model categories and Date range filters. See Filters.

Tableau 2. Feature description

Feature	Description
CIs by model category	Displays the breakdown of operational CIs by associated model category 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 model data and other key attributes	Displays key metrics related to CIs missing model details, ownership, and other key attributes, leading to incomplete records and operational inefficiencies.
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.
CI and asset-related issues	Displays key metrics related to mismatches and missing links between CIs and assets, leading to incomplete asset life cycle tracking and reporting issues.

Filters

Enables narrowing the data shown in graphs and metrics based on model category, date range, or stale CI threshold.

Name	Type	Description
Selected model categories	List	Filters CIs based on the selected model categories. Remarque : Requires the pa_viewer role.
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 model data and other key attributes

Displays key metrics related to CIs missing model details, ownership, and other key attributes, leading to incomplete records and operational inefficiencies.

Tableau 3. CIs missing model data and other key attributes section

Card	Description	Indicators
CIs missing model name	Operational CIs not associated with a model ID or associated with a model ID missing a name.	CIs missing model name
CIs missing model number	Operational CIs not associated with a model ID or associated with a model ID missing a model number.	CIs missing model number
CIs missing model manufacturer	Operational CIs not associated with a model ID or associated with a model ID missing a manufacturer.	CIs missing manufacturer
CIs missing model ID	Operational CIs not associated with a model ID.	CIs missing model ID
CIs missing assigned to	Operational CIs not assigned to a specific user, leading to unclear ownership and delayed action.	CIs missing assigned to
CIs missing location	Operational CIs not associated with a location, leading to gaps in asset tracking and service mapping.	CIs missing location
CIs missing owner	Operational CIs not associated with an owner, leading to unclear accountability and delayed issue resolution.	CIs missing owner
CIs missing managed by group	Operational CIs not managed by a specific ownership group, leading to inefficient support assignment and operational risk.	CIs missing managed by group
CIs missing serial number	Operational CIs missing a serial number, leading to issues with duplicate identification.	CIs missing serial number

Remarque :

Select Show more in the CIs missing model data and other key attributes section to view all the cards.

CI data quality issues

Displays key metrics related to CIs that haven’t been updated or may have duplicate records, leading to outdated information and inconsistencies in the CMDB.

Tableau 4. CI data quality issues section

Card	Description	Indicators
CIs not updated	Operational CIs not updated, causing data gaps and inaccuracies in the CMDB.	CIs not updated in last 7 days CIs not updated in last 14 days CIs not updated in last 30 days CIs not updated in last 60 days CIs not updated in last 90 days Remarque : The CIs not updated card data is additionally filtered based on the Stale CI filter. See Filters.
Duplicate CIs	Operational CIs identified as duplicates based on key matching attributes, causing data redundancy.	Hardware CIs group by

CI and asset-related issues

Displays key metrics related to mismatches and missing links between CIs and assets, leading to incomplete asset life cycle tracking and reporting issues.

Tableau 5. CI and asset-related issues section

Card	Description	Indicators
CIs missing asset	Operational CIs not associated with an asset record, leading to incomplete asset life cycle tracking.	CIs missing asset
Virtual CIs with asset	Virtual assets created for virtual CIs that are operational, leading to inaccurate consumption of HAM licenses.	Assets created for virtual CIs
Assets missing CI	Assets without a matching CI, caused by CIs not being discoverable on the network.	Assets missing CI
CI install status vs. asset state	All CIs where the install status matches or differs from the corresponding asset state.	CI install status vs. asset state matched CI install status vs. asset state mismatched