question CMDB Remediation Rules in ITSM forum

CMDB Remediation Rules

klautrup — Fri, 04 Jan 2019 07:58:38 GMT

Hi,
I have configured a CMDB orphan rule in the Health Dashboard identifying orphan MS SQL Database CIs in cmdb_ci_db_mssql_database if they do not have the CONTAINED BY relation to a MS SQL Instance CI in Fcmdb_ci_db_mssql_instance.

I now want to configure a CMDB Remediation Rule where it seems I have to create a workflow:

If I then click the magnifying glass next to 'Workflow' I get a pop-up allowing me to create a workflow:

Submitting that workflow brings me to the workflow canvas:

Now if I Publish that workflow and return to the create CMDB Remediation Rule form it has put the new workflow in the 'Workflow' field:

But if I try to Submit that it is blanked out:

And hitting the magnifying glass again doesn't show the published workflow (if I open the workflow editor directly I see the workflow as published).

The documentation how to create a CMDB Remediation Rule seems very sparse. Anybody having successfully created such a rule?

Re: CMDB Remediation Rules

Alberto Consonn — Fri, 04 Jan 2019 08:11:23 GMT

Hi,

looking at the error message, please try to change the name of the Workflow, it should NOT match anywhere.

Give a try and let me know.

Please, remember to mark Correct or Helpful if you find my response useful.

Cheers
Alberto

Re: CMDB Remediation Rules

Community Alums — Fri, 04 Jan 2019 10:04:56 GMT

Does the table for the workflow have to match the task type on the rule, so should be "Orphan CI Remediation"?

Re: CMDB Remediation Rules

klautrup — Fri, 04 Jan 2019 10:12:30 GMT

I'm adding the workflow with a unique name and it gives the error (same if I add it with the same name as the Remediation Rule I'm trying to create).

And adding the workflow on the same "Orphan CI Remediation" table also gives the same error and besides doesn't seem to make sense since it is not in that table I want the workflow to delete the orphan MS SQL Database CIs.

Re: CMDB Remediation Rules

Batman3 — Fri, 18 Jan 2019 14:46:35 GMT

running into a similar problem, has there been any update on what was the root cause of the issue?

Re: CMDB Remediation Rules

Shelby Foister — Tue, 29 Jan 2019 20:59:58 GMT

Has anyone heard or seen any resolution to this? I'm running into the same issue on all of my instances.

Re: CMDB Remediation Rules

LaurentChicoine — Wed, 30 Jan 2019 19:33:50 GMT

The table of the workflow should be the associated remediation table so if your remediation rule is for the "Stale CI Remediation" task type, then the workflow should be running on that table. Same thing applies for other remediation task types.

Re: CMDB Remediation Rules

FYL — Wed, 11 Mar 2020 03:34:28 GMT

Found the answer here https://hi.service-now.com/kb_view.do?sysparm_article=KB0725128

Do the following before Submitting the CMDB Remediation Rule

**************************************************

Creation of the Workflow for "Reconcile Duplicate task"
1) Click "New" to create a new Workflow.

2) Fill in the form:
a) for the option of "Table", select "Reconcile Duplicate Task" (reconcile_duplicate_task)
b) For "If condition matches", select "None".

3) [Ensure that the associated workflow remediates duplicate CIs.]

4) Save and Publish the workflow.

Re: CMDB Remediation Rules

Jeff133 — Fri, 30 Oct 2020 22:49:45 GMT

Did you get this to work? I want to create a workflow that will...

Select the duplicate record with the Newest Updated
Set it as the Master record
Set Status="Retired" on all duplicate records
Merge relationships from the duplicates to the Master

Is that possible?

These are the steps that I seem to perform manually many times each week.

Re: CMDB Remediation Rules

Henrik Jutterst — Thu, 21 Apr 2022 10:21:07 GMT

Looking for the same feature as you describe.
Did you have any luck with this in a Workflow?

Re: CMDB Remediation Rules

Christian Chamb — Thu, 08 Jun 2023 14:13:13 GMT

The flow should be created on the same table as the remediation task, for instance, if u are creating a remediation on stale cis, then the workflow should also refer to the stale task table