You are troubleshooting a scenario where Discovery is creating duplicate CIs for the same server. Which table should you inspect to verify the Identification Rule settings for the specific CI class?
Trap 1: discovery_device_history
The discovery_device_history table logs device-level Discovery activity and status, not the identification criteria that decide whether an incoming record matches an existing CI. It is tempting because it is genuinely useful for auditing what Discovery touched and when, which suits tracking failed or skipped devices rather than diagnosing duplicate CI creation.
Trap 2: sys_reconciliation_rule
The sys_reconciliation_rule table stores reconciliation rules that merge duplicate CI records after identification has already matched them, so it cannot explain why two CIs were created instead of one. It is the right place when tuning merge precedence and survivorship between already-identified duplicates.
Trap 3: cmdb_ci_relation
The cmdb_ci_relation table holds relationships between CIs, such as depends-on or runs-on links, and contains no identification criteria, so it cannot reveal why duplicate server records appear. It is the correct table when investigating missing or incorrect relationship mappings rather than duplicate CI creation.
- A
cmdb_identifier_entry
The `cmdb_identifier_entry` table stores the identification rules that Discovery applies per CI class, so inspecting it reveals exactly which attribute combinations are being matched. Duplicates arise when those entries are misconfigured or missing, causing the same server to fail matching and create a new CI record instead.
- B
discovery_device_history
Why it fails: The discovery_device_history table logs device-level Discovery activity and status, not the identification criteria that decide whether an incoming record matches an existing CI. It is tempting because it is genuinely useful for auditing what Discovery touched and when, which suits tracking failed or skipped devices rather than diagnosing duplicate CI creation.
- C
sys_reconciliation_rule
Why it fails: The sys_reconciliation_rule table stores reconciliation rules that merge duplicate CI records after identification has already matched them, so it cannot explain why two CIs were created instead of one. It is the right place when tuning merge precedence and survivorship between already-identified duplicates.
- D
cmdb_ci_relation
Why it fails: The cmdb_ci_relation table holds relationships between CIs, such as depends-on or runs-on links, and contains no identification criteria, so it cannot reveal why duplicate server records appear. It is the correct table when investigating missing or incorrect relationship mappings rather than duplicate CI creation.