Duplicate CI Remediations Tables

adamtoth
Tera Contributor

Hello,

 

I am building a PowerBI dashboard that reports on orphan, stale, recommended, and duplicate health tasks. The first three tables show all states for the tasks (Open, WIP, Closed Complete) however the duplicate table (cmdb_duplicate_ci_remediation) only shows (complete, complete with errors, and failed). Is there any way to show the current open duplicate tasks on that table?

 

Thank you,

 

Adam

4 REPLIES 4

Marshall Parker
Tera Guru

The table you referenced [cmdb_duplicate_ci_remediation] holds the status records for the Duplicate Remediations that have been completed on your instance.

 

To see a list of tasks you want to look at the table Remediate Duplicate Tasks [reconcile_duplicate_task] which should contain a history of both open & closed duplicate tasks that were opened on your instance.

Thanks for the reply. That table does have both. The next issue is we have principal and supporting classes for CIs. Is there any way to filter by class on this table?

The duplicate data is stored across a few different tables:

  • Remediate Duplicate Tasks [reconcile_duplicate_task]  this is a child of the Task table and contains the actual Duplicate Tasks to be assigned & worked
  • Duplicate CI Remediations [cmdb_duplicate_ci_remediation] - Related list that shows any remediation jobs run against a specific task.
  • Duplicate Audit Result [duplicate_audit_result] - Related list that contains entries for each CI in the duplicate [2 or more]. This table uses a Document ID type field to reference a CI table which displays well when looking at the table but is a little more complicated to use in queries for filtering / grouping.

 

For overall metric analysis & the ability to segment by class, you may want to consider the table CMDB Health Results [cmdb_health_result] which is updated whenever a health job is run and contains the current records for each metric. This table has the CI as a reference which would allow for easy filtering by Class and/or Metric and may help you provide overall metrics more easily.

For my use case I need to have both closed and open tasks and be able to filter by class on one tables. But it doesn't that any one of those tables provides that ability in one place.