How to improve CMDB de-duplication part one

Darth Jed
Tera Guru

I may be looking in the wrong places, but it seems like there isn't a lot of information about how to get the most out of the reconciliation tools for the CMDB Health Dashboard. This post is going to be the start of a journey through setting up and customizing the dashboard and its components. I have a specific problem I created for myself and I'm very curious to see if anyone has a solution.

De-duplication. I'm sure this is a concern for everyone who's managing a CMDB. I've built a workflow that handles most duplicates that I can find and after testing it, the workflow seems to work just fine. The problem I have is that I'd rather put this remediation method in the hands of my asset management team so they can handle this day to day cleanup process. When the remediation workflow is executed, the user who triggered it only receives a brief message ("Remediation started") about the workflow being executed. I want to provide better feedback to the user without forcing them to go view the script logs. I've tried using addInfoMessage from the workflow and that only displays messages on the next screen they visit. Hardly useful.

My workflow generates log messages about when the original CI has been identified (the keeper), the number of duplicates found, when a duplicate has been replaced in a related task, the number of related tasks that no longer contain the duplicates, when the duplicates have been deleted, a confirmation of the number of duplicates remaining, confirmation that the discovery source has been cleared, and an abort message for when the keeper has not been identified. Obviously, this is a bit wordy for most users. I just want to display the three most useful messages to the user after the workflow has completed.

1. The abort message or keeper found and number of dupes identified message

2. The total number of related tasks that were updated

3. The confirmation that no duplicates remain

I've found the UI page (cmdb_run_remediations) that is used to display the Run Remediations window and would like to know how to push my messages to that UI page, just like the "Remediation started" message. Does anyone know? richardbrounstein, do you know?

5 REPLIES 5

Manjeet Singh
ServiceNow Employee
ServiceNow Employee

Hi John,


You may find information on these two link helpful:


Setup and configure CMDB Health


Create health inclusion rule


Manjeet, I'm looking for specific coding assistance, not the docs for how to set up the dashboards. Believe me, I've read everything I can find on them. Do you have a more relevant suggestion?


Kannan Nair
Tera Contributor

Hi  John

 

I am also working on the identification and de-duplication. I was going through the reconcile UI page and found that the page is not available in the UI Page list. Hence I am not able to understand how the OOB workflow/business logic is called for reconcile.

We are looking to automate the de-duplication task to avoid working on the de-duplication tasks.

 

Could you please provide some input about the logic that you used to create a custom workflow for remediation and is it possible to automate de-duplication task?

Hi Kumar! I'm currently looking to automate the de-duplication task too, did you find a way to do it?, we were thinking on create a Scheduled Job that should do the "cleaning" but I don't know where to start yet, any help would be appreciated.

 

Thanks!