CMDB optimization
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2023 07:44 AM
Hi community,
Help me on this,
I have to submit a document to be shown to client about CMDB optimization. I want to know the checklist points for CMDB optimization, like we need to explain client, how we can optimize CMDB, in which areas we can optimize the CMDB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2023 11:08 AM
Hi Durga Prasad,
Below are the list of some areas to focus in optimizing CMDB.
1. Data integrations: ( list of data sources fed CMDB, how are they integrated, how the data getting in to CMDB.
2. Data Quality : Assess data quality by accuracy, completeness and relevancy of data stored in CMDB.
3. Data Standards: Standardizing of data model, naming conventions, data formats,
CI type classification.
4. Data Access and controls: Authorization to access data in CMDB and security controls to protect CMDB data.
5. Data Governance : Policies, Procedures, roles and responsibilities to manage data in CMDB.
6. Data Management: Data validation, reconciliation and normalization procedures.
7. Monitoring and Reporting : Metrics and KPI's for monitoring the performance CMDB. Reporting the KPIs to business and identifying the areas of improvement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2023 02:58 AM
Hi subash thanks for reply ,what are the methods or tools or techniques we can use to optimize the CMDB,,
and can u provide recommondations for CMDB optimization.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2023 04:27 PM
These are some key aspects to be considered for CMDB optimization along with methods:
1. CSDM alignment: If CMDB and CSDM data foundations dashboard plugin is activated, we can make use of 'CSDM data foundations dashboard' to see insights about how to improve CSDM alignment. There are certain metrics along with URLs to access detailed playbooks explaining how to improve those metrics. But it is recommended to read CSDM 4.0 white paper and gain a thorough understanding of CSDM before providing optimization recommendations based on this dashboard. We also need to analyze the data that is already populated in various CMDB tables (especially related to services) and connect with service owners, application owners etc. to understand whether existing data is populated in the right tables as per the CSDM 4.0 guidelines. Following is the docs URL for this dashboard:
2. CMDB Data quality: Apart from the CSDM data foundations dashboard, the CMDB data foundations dashboard which comes from the same plugin can give some insights on how to improve the CMDB data quality. Also CMDB health metrics should be configured for completeness, correctness and compliance to get insights about various data quality issues like important fields with missing data, duplicate CIs, stale CIs, Orphan CIs etc. on the CMDB health dashboard. There are also remediation methods like deduplication tasks for mitigating duplicate CIs. Following is the docs URL regarding this:
Identification rules should be refined for those CI classes where high number of duplicate CIs are getting created. Reconciliation rules should be set for CI classes which are populated by more than one method. Following URL explains about identification and reconciliation engine (IRE):
3. CMDB governance: Detailed process, procedures, policies etc. related to CMDB should be documented and updated regularly. The document should cover topics like CI lifecycle management, RACI for ongoing management of CMDB, info on key CI classes (key attributes, info of CI class owners, data population methods, naming conventions, access rights etc.), interaction with other processes, audit methodology, reporting & dashboards used etc.
Each of the CI classes which are populated in the CMDB should have CI class owners identified. Data certification should be used for periodic validation by CI owners for critical attributes (especially those which are populated manually) in important CI classes. It is explained below:
4. CMDB automation: CMDB data population should be automated as much as possible using ServiceNow discovery and integration with 3rd party tools used by the organization (E.g. SCCM, Intune, JamF etc.). Service Graph Connector is the recommended method for integrations as it goes through the Identification and reconciliation engine (IRE).
Also for bulk manual data imports into the CMDB, integration hub ETL is the recommended method as it goes through IRE.
5. Asset & CI management: As asset management & configuration management are closely interrelated processes, it is important for any organization to define what will be managed primarily as an asset and what will be managed primarily as a CI. Asset-CI attributes and status synchronization should be defined as per the organization's requirements. Following URL has more details: