Preview existing Operational Technology (OT) device records in the Configuration Management Database (CMDB) before you import any new records from the staging table. By previewing existing records, you can avoid reconciling or merging unrelated records.
Before you begin
Role required: ot_excel_import_user
About this task
If a matching configuration item (CI) is in the CMDB when you import OT devices from the staging table, existing records may reconcile or merge with new records. Matching CIs include the hostname, MAC address, or serial number. To
avoid accidentally reconciling or merging records, you can preview the existing records that share the matching CIs with the records in the staging table.
Procedure
-
Navigate to .
-
Select the List (
) icon.
-
Under the OT Excel SGC - Import Task module, select one of the available lists.
-
Select an Import Task record that you want to verify has any matching CIs.
-
In the Validation comments column, check if a matching CI has been found.
The Validation comments column explains the matching CI that was found and contains a link to the matching CI. When a matching CI is found in the
CMDB, the Validation state is set to
Partially Valid. The following table lists the matching CI validation comments.
Table 1. Matching CI validation comments
| Matching CI |
Validation comment |
| Hostname |
Same transformed name found for another CI:<Link to CI> |
| MAC address |
Same MAC address [MAC address] found for another CI:<Link to CI> |
| Serial number |
Same serial number [serial number] found for another CI: <Link to CI> |
- Optional:
View the matching CI by selecting it from the Matching CI in the CMDB column.