Micro Certification – CMDB Health:
I recently completed my MC : CMDB Health. Thought this article might help someone.
Have made a snapshots on how to resolve some tasks from MC.
Schedule the CMDB Health scheduled jobs to execute two times a day at 7AM and 7 PM
Add Recommended fields.
Task 07: Create Orphan rule
Task 09: Remediate Duplicates
Task 10: Configure Reclassification System Property
Task 11: Build Simple Query
Task 12: Build Query with Non-CMDB Table
Task 13: Configure Remediation:
- Schedule the CMDB Health scheduled jobs to execute two times a day at 7AM and 7 PM.
- Add Recommended fields:
- Task 07: Create Orphan rule:
From the Email Server class, configure an orphan rule that specifies a relationship to determine which Email Server applications do not have a Runs On:Runs relationship to a Server [cmdb_ci_server]
- Task 09: Remediate Duplicates
REQUIREMENT:
As the Cloud Dimensions CMDB administrator, using the Duplicate CI Remediator wizard (De-duplication tasks), remediate the duplicate Windows Server CI found on the de-duplication task list to meet the following requirements:
-Retain the master CI which is the oldest CI record based on creation data
-Use the cost center, company, and assigned to values from the duplicate record (non-master CI)
-Merge all relationships from both server records named OWA-SD-01
-Delete the duplicate server record
After completing the wizard, execute the Correctness Scorecard scheduled job to calculate the new results and display them on the CMDB Group Health Correctness Scorecard for the Unix and Windows Servers CMDB group.
Navigate to De-duplication Tasks
Open Windows Server Task (Ex: DUP0001014)
Select "Remediate"
Choose the option: Use the Duplicate CI Remediator (Recommended) and Click Next
- Select Main CI
Choose the CI with Maximum number of Related Items(also check created by and open the old record)
Then, Select "Remediate Manually"
- Merge Attribute Values
On this page you will find list of Attributes that have duplicate values.
In the "Other Values" column Click on “1 Other Values” and Choose 2nd option and Click Select
for below attributes:
Cost center
Company
Assigned to
Click Next.
Note: We are deleting the record here. So, open both records in cmdb_ci table and check the record we want (created by is old record) and remember the fields cost center, company and assigned to.
- Merge Relationships
Choose the option: “Merge all relationships from the duplicate Cis to the main CI”. Click Next.
- Duplicate CI Actions
Choose the option: “Delete”. Click Next.
- Review and Confirm
Click "Remediate".
From the De-Duplication Task list verify the Windows task displays with a State of Closed Complete.
Execute the Correctness scheduled job.
- Task 10: Configure Reclassification System Property
REQUIREMENT:
As the Cloud Dimensions CMDB administrator, you are tasked to reconfigure the 3 reclassification system properties to force the creation of a CI Reclassification task for any CMDB class upgrade, downgrade or switch.
Go to system properties and disable the properties - glide.class.downgrade.enabled, glide.class.switch.enabled, glide.class.upgrade.enabled
- Task 11: Build Simple Query:
Go to CMDB Query Builder à Search for Windows Server Class, drag and add to CMDB Query Builder, Select the Starting Node you added, click on funnel icon above the node and the filer condition opens and add the filter that Operating system is one of “Windows 2012 R2 Standard, Windows 2016 Standard, and Windows 2019 Datacenter”, Save and Run the Report. Check the records returned and add the number(got 68 records) returned in Description field. Run the Scheduled Job Correctness and validate the task.
- Task 12: Build Query with Non-CMDB Table:
REQUIREMENT:
As the Cloud Dimensions CMDB administrator, use Query Builder, to meet the following requirements:
- Build a query named Critical Incidents with No Owner that displays any configuration item that does not have the Owned by field populated, and is associated to a priority 1 - Critical incident
- This means your query should be comprised of two connected items:
- A CMDB Class > Configuration Item that does NOT have the Owned by field populated
- A Non-CMDB Table > Incident item that's priority is 1 - Critical
- Save and run the query
- In the Description field, enter the number of records returned and then save the query again.
- Task 13: Configure Remediation:
Requirement: Configure the workflow, that when executed, writes to the short description field of the orphan task the following: 'Workflow launched for task number [actual task number of orphan rule]'
Steps:
Create a workflow with - Name: Remediate Orphan WF
- Table: Orphan CI Remediation [orphan_ci_remediation]
From core tab, add Run Script to workflow.
Add Set Values to workflow.
Validate and publish the workflow.
Create CMDB Remediation Rule:
Go to Health Preferences and enable “Create Task” under Health Metrics
Run the Scheduled Job – Correctness and open Orphan Task – click on Remediate and check if Short Description has been updated.
