Duplicate CIs report - What is considered a duplicate?

Henrik Jutterst
Tera Guru

Viewing the "CMDB Dashboard - CMDB View" I found the "Duplicate CIs" report a question got to me: How does ServiceNow calculate the CI as a duplicate and where can I modify this?

In the report I can see "Metric is Duplicate", but what is a duplicate according to ServiceNow and where can I modify this if so?

find_real_file.png
Fig. 01 - CMDB Dashboard - CMDB View

 

find_real_file.png
Fig. 02 - Duplicate CIs report

I looked into table: cmdb_health_metric but without any luck to see how Duplicate value was calculated.

Any idea?

1 ACCEPTED SOLUTION

glennpinto
Kilo Guru

The duplicates on the CMDB Dashboard are derived from CIs that are tagged with the discovery source field of duplicate. When this happens, a de-duplication task record is created listing or grouping all the duplicate CIs. 

A CI is tagged as a duplicate either during ServiceNow discovery. During the identification phase, the IRE (hardware rule) is used to identify if the CI exists or does not exist in the CMDB to determine if an update or insert should occur. If multiple CIs exist in the CMDB as identified by the Hardware rule, then the oldest CI (in terms of creation date) is updated and its discovery source is defined as ServiceNow, however the other duplicate CI is not updated and its discovery source is flagged as duplicate. As a result of this process, a de-duplication task is created and the two CIs will display on the CMDB Dashboard under the Correctness Scorecard only after the Correctness scheduled job is run.

A second scenario exists if a duplicates exist in the CMDB and CIs do not have any discovery source defined. In this case, after the Correctness schedule job is run, these CIs will be added automatically to a de-duplication task record and also automatically be part of the calculation on the Correctness Scorecard.

View solution in original post

6 REPLIES 6

glennpinto
Kilo Guru

The duplicates on the CMDB Dashboard are derived from CIs that are tagged with the discovery source field of duplicate. When this happens, a de-duplication task record is created listing or grouping all the duplicate CIs. 

A CI is tagged as a duplicate either during ServiceNow discovery. During the identification phase, the IRE (hardware rule) is used to identify if the CI exists or does not exist in the CMDB to determine if an update or insert should occur. If multiple CIs exist in the CMDB as identified by the Hardware rule, then the oldest CI (in terms of creation date) is updated and its discovery source is defined as ServiceNow, however the other duplicate CI is not updated and its discovery source is flagged as duplicate. As a result of this process, a de-duplication task is created and the two CIs will display on the CMDB Dashboard under the Correctness Scorecard only after the Correctness scheduled job is run.

A second scenario exists if a duplicates exist in the CMDB and CIs do not have any discovery source defined. In this case, after the Correctness schedule job is run, these CIs will be added automatically to a de-duplication task record and also automatically be part of the calculation on the Correctness Scorecard.

Hi Glenn and thanks for the feedback on this topic. 

It was a bit unclear when I wrote this post, but it cleared out later and I forgot to update the post. But thanks for the info.