Duplicate CI Remediations Tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 06:38 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 08:46 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 10:36 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 11:03 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2025 12:20 PM
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.