CMDB Health Dashboard : Query on calculation

[KOUSTAV DUTTA]

Hi Team, Can anyone help me with the following related to CMDB Health Dashboard?

1. How the total CI number is calculated? i.e. in every KPI, there is a notation like Recommended 10/100 10%..then how the 100 is calculated..

2. For Staleness, I found some community article which mentions that the effective duration is considered from the most recent discovery where as the Doc mentions updated date..which is correct?

3. We have SCCM integration running in our instance. So I have manually ran a report to get the count of Computer CI whose most recent discovery date and updated date is prior staleness effective days(45), but the count does not matches with the one displayed in the dashboard. In my report ~8k records are coming where as in the dashboard only 300 are showing.. any idea why?

Thanks for any help. 🙂

[Sandeep90 · Accepted solution]

Here are responses to your questions

1. Please refer to this doc to know how the total is computed. If you need further explanation let me know.

2. sys_updated_on filed is used to compute the staleness and not last_discovered.

3. Check if there are any health inclusion rules that are applied, this can reduce the total number of CIs that you are seeing in the health dashboard. You can view health inclusion rules by going to CI Class Manager -> Hierarchy -> (Class Name) -> Health -> Health Inclusion Rules

[KOUSTAV DUTTA]

Thanks Sandeep for your response!!

The article you shared is very useful, however I am still not able to match the count. I saw that there are some health inclusion rules on base cmdb_ci with a filter class=cmdb_ci_server..when I changed it to hardware, the count got updated but not the exact what is there is CMDB Hardware table i.e. in cmdb_ci_hardware table there are approx 90k record but in the staleness, it is showing only 73k

Similarly for staleness count, I have modified the rule to run on cmdb_ci_computer,and effective duration as 45days, but from the manual filter(updated more that 45 days ago) i am getting around 8k records but in the staleness, it is only 315(discovered by SCCM).

Do you have any idea on this?

[Sandeep90]

Please also add a filter to include only active CI's and check if it helps to match the count. Even for staleness, I would suggest you check on the health inclusion filters and only consider CI with active flag true.