In CMDB health completeness getting duplicate entries for metric complete and correct

Dheeraj24
Kilo Contributor

‎09-18-2023 03:29 AM

Hi All,

Need your help

We have a custom table "u_cmdb_health and this table is retrieving duplicate entries for metric "correct" and "complete and in CMDB dashboard completeness we can see double count for for each record

Dheeraj24_0-1695032484353.png

Earlier cmdb health completeness report the aggregation was "count" so the application service was showing the double count and later we changes the aggregation to "count distinct" and now on dashboard we are able to see approx. exact count but we need to stop the duplicate entries to custom table(u_cmdb_health)

Dheeraj24_1-1695032598103.png

 

So could anyone please help or guide how can we resolve this issue

 

 

0 Helpfuls
  • 232 Views
1 REPLY 1

Sandeep90
ServiceNow Employee
ServiceNow Employee

‎01-04-2024 07:27 AM

@Dheeraj24 If the problem is you are seeing duplicate results in completeness because you have duplicate records then please remediate those duplicate tasks to resolve the issue rather than trying to find the workaround. 

0 Helpfuls