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

[debendudas]

Hi @jack33 ,

Not all CIs are checked by the Duplicate Metric when the "CMDB Health Dashboard - Correctness Score Calculation" job runs. 

When CMDB Health - Correctness job runs, the Duplicate Metric only checks CIs that have Identification Rules defined, and also meet one of below conditions:

• One of the duplicated CIs has empty Discovery Source attribute
• There is an active de-duplicate task (reconcile_duplicate_task) for the duplicated CI

Please see the article for more information: CMDB Health - Duplicate Metric algorithm - Support and Troubleshooting (servicenow.com)

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍! 

[jack33]

Hi @debendudas , Thank you for your reply

Ya so we don't have issue with duplicate denominator, want to understand how system updating denominator of orphan and stale as  > 1,96,20,857 from where this count populate?

[debendudas]

The denominator represents the total number of CIs that has been validated by the orphan rules.

[jack33]

understood, 

I written orphan rule on computer table and hardly i have 9 lac CI in the table, and the cmdb_ci table have total 2,04,89,134 records then how only these many are validated.How to confirm orphan rule only validate 1cr+ records