Indicators used in the CMDB success advisor for HAM dashboard
Summarize
Summarized using AI
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.
Summary of Indicators used in the CMDB success advisor for HAM dashboard
The CMDB Success Advisor for Hardware Asset Management (HAM) dashboard provides key indicators that help ServiceNow customers monitor and improve the quality, completeness, and synchronization of hardware asset and configuration item (CI) data in their CMDB. These indicators enable high-level visibility into asset and CI data health, supporting better asset management and CMDB accuracy.
Show less
Key Features
- Asset and CI Linkage Indicators: Track assets created for virtual CIs, assets missing linked CIs, and CIs missing linked assets to ensure proper relationships between assets and CIs.
- Normalization and Matching Status: Categorizes CIs by normalization status and model category, and checks alignment between CI installation status vs. asset state, and CI lifecycle stage vs. asset lifecycle stage (requires CSDM Activation plugin).
- Data Completeness Indicators: Identify CIs missing critical data fields such as assigned owner, location, managed by group, manufacturer, model ID, model name, model number, and serial number.
- Data Freshness Monitoring: Highlight CIs not updated within specific time frames (7, 14, 30, 60, and 90 days) to ensure data currency.
- Duplicate Detection: Shows the count of duplicate CIs based on the HAM duplicate CI audit process, helping maintain data uniqueness.
- Grouping and Categorization: Hardware CIs are grouped daily by model category and discovery source for easier trend analysis and reporting.
Key Outcomes
By utilizing these indicators, ServiceNow customers can:
- Quickly identify and address gaps or inconsistencies in hardware asset and CI data.
- Ensure accurate synchronization between assets and their corresponding CIs for reliable asset management.
- Maintain completeness of critical CI attributes essential for operational and compliance purposes.
- Monitor data recency to keep the CMDB up to date and relevant.
- Reduce duplicate records to improve CMDB integrity.
- Leverage grouped data insights for better decision-making and targeted remediation efforts.
Indicators enable viewing of high-level metrics that highlight data quality, completeness, and synchronization issues across hardware assets and configuration items (CIs).
CMDB success advisor for HAM dashboard indicators
- Assets created for virtual CIs
- Total number of virtual CI assets in the Hardware [alm_hardware] table created daily, where the life cycle stage of CI is operational, the asset field is not empty, and the CI is marked as virtual.
- Assets missing CI
- Total number of hardware assets in the Hardware [alm_hardware] table missing a linked CI from the Hardware [cmdb_ci_hardware] class, measured daily, where the CI is operational, the asset is actively in use, and no CI is linked to the asset.
- CIs by normalization status
- Total number of CI records from the Hardware [cmdb_ci_hardware] class, measured daily and grouped by model category and HAM normalization status, based on the Normalized status field on the associated hardware product model.
- CI install status vs. asset state matched
- All CI records from the Hardware [cmdb_ci_hardware] class where the installation status correctly aligns with the expected asset state, promoting accurate and reliable asset management.
- CI install status vs. asset state mismatched
- All CI records from the Hardware [cmdb_ci_hardware] class with an installation status that doesn’t align with the expected asset state, resulting in erroneous asset management.
- CI lifecycle stage vs. asset lifecycle stage matched
- All CI records from the Hardware [cmdb_ci_hardware] class with a life cycle stage matched between the CI and its linked asset. This indicator is supported only on instances where the CSDM Activation plugin (com.snc.cmdb.csdm.activation) is installed and migrated to life cycle stage.
- CI lifecycle stage vs. asset lifecycle stage mismatched
- All CI records from the Hardware [cmdb_ci_hardware] class with a life cycle stage mismatch between the CI and its linked asset. This indicator is supported only on instances where the CSDM Activation plugin (com.snc.cmdb.csdm.activation) is installed and migrated to life cycle stage.
- CIs missing asset
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a linked asset, measured daily, where the life cycle stage of CI is operational and no asset is associated with the CI.
- CIs missing assigned to
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing an assigned owner, measured daily, where the CI lacks an assigned owner.
- CIs missing location
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a location, measured daily, where the CI doesn’t have a location assigned.
- CIs missing managed by group
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a managed by group, measured daily, where the CI doesn’t have a managed by group assigned.
- CIs missing manufacturer
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a manufacturer, measured daily, where the CI doesn’t have a manufacturer specified.
- CIs missing model ID
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a model ID, measured daily, where the CI doesn’t have a model ID or model display name specified.
- CIs missing model name
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a model name, measured daily, where the CI doesn’t have a model name specified, with or without a model ID.
- CIs missing model number
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a model number, measured daily, where the CI is not associated with a model ID, or is associated with a model ID that is missing a model number.
- CIs missing serial number
- Total number of CI records from the Hardware [cmdb_ci_hardware] class missing a serial number, measured daily, where the CI doesn’t have a serial number assigned.
- CIs not updated in last 7 days
- Total number of CI records from the Hardware [cmdb_ci_hardware] class not updated in the last seven days, measured daily, where the update timestamp is older than seven days.
- CIs not updated in last 14 days
- Total number of CI records from the Hardware [cmdb_ci_hardware] class not updated in the last 14 days, measured daily, where the update timestamp is older than 14 days.
- CIs not updated in last 30 days
- Total number of CI records from the Hardware [cmdb_ci_hardware] class not updated in the last 30 days, measured daily, where the update timestamp is older than 30 days.
- CIs not updated in last 60 days
- Total number of CI records from the Hardware [cmdb_ci_hardware] class not updated in the last 60 days, measured daily, where the update timestamp is older than 60 days.
- CIs not updated in last 90 days
- Total number of CI records from the Hardware [cmdb_ci_hardware] class not updated in the last 90 days, measured daily, where the update timestamp is older than 90 days.
- Duplicate CIs
- Total number of CI records from the Hardware [cmdb_ci_hardware] class identified as duplicates, measured daily, based on the results of the HAM duplicate CI audit process.
- Hardware CIs group by
- Total number of CI records from the Hardware [cmdb_ci_hardware] class, measured daily and grouped by model category and discovery source.