Several types of components are installed with Identification and Reconciliation (included in the com.snc.cmdb plugin), including tables.

Tables installed

TableDescription
Identifier

[cmdb_identifier]

 Identification rule sets defined for different classes of CIs.
Reconciliation Definition

[cmdb_reconciliation_definition]

 Static reconciliation rules defined for different classes of CIs at the table and field level.
Dynamic Reconciliation Definitions

[cmdb_dynamic_reconciliation_definition]

 Dynamic reconciliation rules defined for different attributes and classes.
Identifier Entry

[cmdb_identifier_entry]

 Rule entries with different priorities assigned to each identifier.
Duplicate Audit Result

[duplicate_audit_result]

 Duplicate audit results corresponding to a specific duplicate task. These results are generated automatically during the identification process and should not be added manually.
Remediate Duplicate Task

[reconcile_duplicate_task]

 Task to address duplication that is detected during the identification process. Records are generated automatically, and users should not add records manually.
Reclassification Task

[reclassification_task]

 Reclassification tasks that were generated during the identification process.
Data Source History

[cmdb_datasource_last_update]

 Information about the last data source that updated each attribute. Used to determine if a data source can update a stale CI.
Data Source Staleness Definition

[cmdb_datasource_staleness]

 Effective duration per data source. When effective duration is exceeded, then CMDB Health determines that the information provided by that data source is stale.
Identification Engine Context

[cmdb_ie_context]

Input payload, and data source (cmdb_ci’s discovery_source) that will be used as input for a specific identification engine API. Stores information about which specific identification engine API will be called (identifyCI or createOrUpdateCI API). Also stores information about enhanced IRE options used in Identification Simulation.

Note: Internal table used by identification simulation.
Identification Engine Run

[cmdb_ie_run]

Specific cmdb_ie_context record that was used to run against the identification engine. Also details about the output payload returned by APIs, such as start and end time of the run and whether the run was successful.

Note: Internal table used by identification simulation.
Identification Engine Log

[cmdb_ie_log]

Identification engine logs for a specific cmdb_ie_run simulated in the identification simulation. Also details about logs level and order.

Note: Internal table used by identification simulation.
IRE Data Source Rule

[cmdb_ire_data_source_rule]

 IRE data source rules.
CMDB IRE Partial Payloads

[cmdb_ire_partial_payloads]

Payload items that were determined to be partial, and which might be later matched with an incoming payload. If a partial payload is matched and processed, it is deleted from the CMDB IRE Partial Payloads table.

Partial payloads older than 90 days are deleted from the table.

For more information about usage of this table in IRE processes, see Identification and Reconciliation engine (IRE).
CMDB IRE Partial Payloads Index

[cmdb_ire_partial_payloads_index]

Identifier keys associated with partial items. IRE uses those keys to try to match with identifier keys of incoming payloads.

For more information about usage of this table in IRE processes, see Identification and Reconciliation engine (IRE).
CMDB IRE Incomplete Payloads

[cmdb_ire_incomplete_payloads]

Incomplete items, stored using JSON format as incomplete payloads. Incomplete items are stored for the purpose of logging payloads with irrecoverable errors, and are never processed again.

The table is configured for table rotation, with duration of one day and seven table rotations.

For more information about usage of this table in IRE processes, see Identification and Reconciliation engine (IRE).
IRE Output Aggregate Stats

[cmdb_ire_output_aggregate_stats]

This table is populated when RTE invokes IRE, for example, when processing integrations.

Details about data inserted by Import Sets or Robust Transform Engine (RTE) to the CMDB (via IRE). Numbers of items inserted, partial items, and updated items, are stored for each type of CI, per run.
IRE Output Target Items

[cmdb_ire_output_target_item]

This table is populated when RTE invokes IRE, for example, when processing integrations.

Details about data inserted by Import Sets or Robust Transform Engine (RTE) to the CMDB (via IRE). Target class and the sys_id are stored per ImportSet row id, within a run.

For this table to populate, RTE must pass the ire_output_detailed_stats property.
Reclassification Restrictions

[cmdb_ire_reclassification_restriction]

 Reclassification restriction rules. These rules prevent switch and downgrade reclassification updates for specific source and target classes. For more information, see Configure CI reclassification during IRE processing.

User roles installed

Role Description
cmdb_payload_admin Automatically assigned to users with the cmdb_admin role for internal use only.