Total CIs in CMDB Workspace is not matching with the cmdb base table count

[VennilaP]

Hi All,

We have a total of more than one million CIs in cmdb_ci table but in CMDB Workspace the total count shows as 4 million. I checked the indicator and it seems that it puuls all the CIs processed by IRE. Am I missing anything? 

Thanks,
Vennila

[Prashanth redd4]

This is because as some health inclusion rule running for different child class for correctness KPI hence due to that CI count is not matching, Please cross check once and you are able to find the same.

After that run the Health rule scheduled job to get the correct Count.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

Prashanth Reddy

[VennilaP]

Thanks Prashanth!! Let me look in to health inclusion rules

[David104]

Hi Venilla,

Which metric are you looking at in CMDB Workspace? Is that the 'Total CI' value on the workspace home page, or are you looking at the CMDB 360 tab?

It sounds odd if your CMDB_CI table shows around 1 million rows and Workspace is reporting 4 million. For me, that might make sense if you are looking at "Total CMDB 360" records in the CMDB 360 tab, as you will see a row for each discovery source, for each CI, and the cmdb_multisource_cmdb table might not cleanup the same way as the CIs themselves.

If the "Total CIs" value in the workspace homepage is significantly more than the actual number of CI records that you have, then that is odd. Are you looking the total rows on the cmdb_ci.list?

[VennilaP]

Hi David,

I see 4M records in the homepage and 1M in the CMDB360. I have attached the screenshots.

Yes , I m looking at the total count in cmdb_ci (

 1,152,684