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

Henrik Jutterst
Tera Guru

Anyone here with info on how this is done?

Henrik Jutterst
Tera Guru

How can I see what is considered a duplicate?

Sudhakara Redd2
Tera Contributor

Hi Henrik,

We have CI identification rules for each CMDB CI table. Based on the identification rule, CI records will create/update. if it finds CI as duplicate, it will update Discovery source as Duplicate. 

Ok, but just to be clear. If I want to set up a rule to report on all CI's that have the same fqdn from cmdb_ci and all tabled that are extending it. Where is that done and how?

I was assuming that this is done in (filter navigator) "CI Class Manager" under "CI Identifiers" and then Identification tab.