Components installed with CMDB Health
Summarize
Summary of Components Installed with CMDB Health
The CMDB Health feature, part of the com.snc.cmdb plugin, installs various components including tables, properties, and scheduled jobs that enhance the management of Configuration Management Database (CMDB) health metrics and performance. Understanding these components is essential for maintaining effective oversight of your CMDB health.
Show less
Key Features
- Properties Installed:
- glide.cmdb.serviceshierarchylimit: Sets a cap on the number of service CIs in the CMDB service dashboard (default: 10,000, max: 100,000).
- glide.cmdb.servicesquerylimit: Limits the number of application services processed for the Service View (default: 1,000, max: 10,000).
- glide.cmdb.serviceassociatedciquerylimit: Controls the number of CIs associated with application services that can be processed (default: 1,000, max: 10,000).
- Scheduled Jobs Installed:
- Completeness Score Calculation: Evaluates the completeness KPI of CMDB health.
- Compliance Score Calculation: Assesses compliance KPI for CMDB health.
- Correctness Score Calculation: Measures correctness KPI.
- Relationship Score Calculation: Analyzes CI relationships KPI.
- Relationship Compliance Processor: Checks compliance of relationships against suggested rules.
- Tables Installed:
- CMDB Health Metric: Tracks settings and thresholds for all health KPIs and metrics.
- CMDB Health Result: Stores results from the latest CMDB health processing cycle.
- CMDB Health Scorecard: Provides current and historical health scores.
- CMDB Health Orphan Rule: Contains rules for identifying orphan records.
- CMDB Recommended Fields: Lists recommended fields for each class.
- CMDB Health Metric Status: Monitors the status of KPIs and metrics during processing.
- CMDB Health Processor Status: Tracks processing progress for each KPI and metric.
- CMDB Relationship All Rules Health Results: Stores results related to relationship health for reporting.
Key Outcomes
By leveraging these components, ServiceNow customers can effectively monitor and enhance the health of their CMDB. The properties allow for performance tuning based on the scale of services being managed, while the scheduled jobs and tables enable comprehensive tracking and reporting of health metrics, compliance, and relationship integrity.
Several types of components are installed with CMDB Health (included in the com.snc.cmdb plugin), such as tables, properties, and scheduled jobs.
Properties installed
| Property | Description |
|---|---|
| glide.cmdb.services_hierarchy_limit |
Maximum number of service CIs that can appear in the CMDB service dashboard. This limit applies to any child class of the Service Instance [cmdb_ci_service_auto] class.
|
| glide.cmdb.services_query_limit |
Maximum number of application services (any class extending the Service [cmdb_ci_service] class) that can be processed for the Service View of the CMDB Health Dashboard. Use this property to manage performance when there are large numbers of application services to process.
|
| glide.cmdb.service_associated_ci_query_limit |
Maximum number of CIs associated with application services (any class extending the [cmdb_ci_service] class) that can be processed for the Service View of the CMDB Health Dashboard. Use this property to manage performance when there are large numbers of such CIs to process.
|
Scheduled jobs installed
| Scheduled job | Description |
|---|---|
| CMDB Health Dashboard - Completeness Score Calculation | Script for calculating the completeness KPI of CMDB health. |
| CMDB Health Dashboard - Compliance Score Calculation | Script for calculating the compliance KPI of CMDB health. |
| CMDB Health Dashboard - Correctness Score Calculation | Script for calculating the correctness KPI of CMDB health. |
| CMDB Health Dashboard - Relationship Score Calculation | Script for calculating the CI relationships KPI of CMDB health. |
| CMDB Health Dashboard - Relationship Compliance Processor | Script for calculating compliance of relationships with suggested relationships, and with hosting and containment rules. |
| Add Identifier Fields In Recommended Rules | Sets all criterion attributes from all active identifier entries from all active identification rules, as recommended fields. These added recommended fields are then checked by the CMDB Health Dashboard - Completeness Score Calculation scheduled job when evaluating the recommended health metric. |
| Remove Identifier Fields In Recommended Rules | Identifies any recommended field that is a criterion attribute in any active identifier entry in any active identification rule. Then removes the recommended setting for that field. |
Tables installed
| Table | Description |
|---|---|
| CMDB Health Metric [cmdb_health_metric] |
Details such as if a KPI or metric is enabled, maximum failure threshold, and other settings for all CMDB Health KPIs and metrics. |
| CMDB Health Result [cmdb_health_result] |
Results from the most recent CMDB Health processing cycle. |
| CMDB Health Scorecard [cmdb_health_scorecard] |
Current and historic health scores. Status of historic score records is 'Historic', and of latest score records is 'Complete’. |
| CMDB Health Orphan Rule [cmdb_health_orphan_rule] |
Rules for calculating orphan records per class. |
| CMDB Recommended Fields [cmdb_recommended_fields] |
Recommended fields per class. |
| CMDB Health Metric Status [cmdb_health_metric_status] |
Internal table that tracks the status of each KPI and metric that is being
processed. Includes status, processing time, and processing start date. State for
a KPI or metric changes from 'In Progress' to either of: Processing of a timed out KPI or metric continues on the following
day.
|
| CMDB Health Processor Status [cmdb_health_processor_status] |
Internal table that tracks the processing progress of each KPI and metric. Contains a list of tables that are processed for each KPI and metric, and processing status. Classes are processed sequentially, changing status from Draft -> In Progress -> Complete. |
| CMDB Relationship All Rules Health Results [cmdb_health_result_rel_all] |
Stores results about relationship health, to be used by the All Relationships report. |