CMDB dashboard - correctness score

Bishal Sharma1
Tera Contributor

‎06-06-2022 03:54 AM

Hi Experts,

We are encountering an unusual behavior in the CMDB dashboard - correctness score. 

Issue: There are 916 ci's available in the u_database_instance_uk class. Out of 916, 769 ci's are showing as orphan (which means that they dont have record in the cmdb_rel_ci table). When checked, it is found that out of those 769 orphan ci's 137 are having the relationship records in the cmdb_rel_ci table.

I would like to know, if 137 ci's have relationship in the cmdb_rel_ci table then why they are showing up as orphan in the CMDB dashboard - correctness score card.

Orphan Rule:

find_real_file.png

 

 

 

It's been 3 months and we are still unable to find the root cause.

Hence, any help would be appreciated.

 

Thanks & Regards,

Bishal Sharma

Labels:
Preview file
55 KB
0 Helpfuls
  • 1,260 Views
3 REPLIES 3

Kevin Callagha1
Tera Contributor

‎06-06-2022 05:36 AM

If you look at things from the DB CI, do you see a relationship to the host? If so, what type is it? 

0 Helpfuls

Bishal Sharma1
Tera Contributor
In response to Kevin Callagha1

‎06-06-2022 05:54 AM

Hi Kevin,

 

This is what showing in the database ci.

 

find_real_file.png

Preview file
37 KB
0 Helpfuls

Sandeep90
ServiceNow Employee
ServiceNow Employee

‎06-06-2022 07:11 AM

Orphan results for relationships are computed if they don't satisfy the given relationship condition. Can you check the description of the result, it should indicate why the failure is created.