In CMDB dashboard in correctness widget for orphan can see wrong denominator

[jack33]

Hi All,

In CMDB dashboard ,in correctness scorecard, wrong denominator is getting displayed i.e. 1,96,20,857 this is not the right count. I have applied orphan rule on computer table so count should be same as Duplicate rule denominator(386837-Duplicate rule is on cmdb_ci table). Please help to understand root cause and what is the  solution

Thank you in advance

[jack33]

hi @debendudas 

Can you please help here?

Thank you in advance

[debendudas]

Hi @jack33 ,

The number of CIs that will be validated by Orphan rule are based on below

1. Health Inclusion Rule

2. CI Classes for which you have defined the Orphan rules

For an example:

In your servicenow instance can have 1000 CIs in cmdb. Out of which 50 are Servers (30 Windows Server, 20 Linux Server), 20 are Printer and rest of the CIs belong to different CI classes.

Now if you define an Orphan Rule for only Server Class then only the Server CIs will be validated so the denominator will be 50.

If you define Orphan Rule for both Server and Printer Class, then CIs of both of the Classes will be validated so the denominator will be 50+20=70.

[jack33]

Hi debendudas

In my system i have only one orphan rule, which is on computer. And computer table have 9 lac of records,so expected denominator is 9 lac right, but i can see 1 cr + value for orphan rule.Also health inclusion rule is on computer table only

Can you please help to understand where is the issue?

Thank you in advance

[jack33]

Hi @debendudas 

can you please share your thoughts

Thank you

[debendudas]

Hi @jack33 ,

Firstly, navigate to cmdb_health_orphan_rule table and check if any Orphan rule is present apart from the Computer table or not.

Secondly, as you mentioned you have 9lakhs CIs in Computer class, are these 9lakhs CIs only present in Computer class or the count includes the child classes of computer as well? If you open the cmdb_ci_computer and do group by "Class", you will get the ci count for each class.

Please note if you define an Orphan rule in Computer class then all its child classes (Server, Linux Server, Windows Server etc.) will also follow the same rule.

Also, please execute the cmdb health schedule jobs for getting the accurate counts.