Why are my CMDB Group Health Dashboards not calculating?

David Anderson2
Kilo Expert

SUMMARY
The CMDB Group Dashboards, based on CMDB Queries, are returning inaccurate measurements (100% and 0/0 counts).

find_real_file.png find_real_file.png

BACKGROUND
I identified two attributes as 'recommended' for applications (version and installed).

I have established a CMDB Query identifying applications that run on servers and I have verified that the query returns a list of applications as the first column (start node is application).  In my personal instance, I wanted a list of applications that are running on an AIX server.  The query returns 7 rows as three applications are running on two servers (SAP Web 01, 02, and 03 run on SAP AppSrv01 and SAP AppSrv02) and one application (SAP Web 04) is running on one server (SAP AppSrv02).  

For the four applications, I verified that the recommended attribute of version is 100% populated and the recommended attribute of installed is 0% populated.  I am expecting the health report to identify the missing recommended attributes.

I have established a CMDB Group, type of Health, based on the CMDB Query I built.  I verified that the CMDB Group is accessing/returning the four distinct applications.

I executed the CMDB Health Jobs and they ran to completion (no errors).

I am expecting to see the four applications as the denominator for the recommended, required, duplicate, orphan, and staleness metrics.

1 ACCEPTED SOLUTION

David Anderson2
Kilo Expert

Ok, I feel silly.  According to the ServiceNow documentation, 

CMDB Group Type of HEALTH sets CMDB Health to monitor the health of the group CIs and aggregate health results for the group as a whole.  Can be populated only be encoded queries.

Jakarta - CMDB Groups

View solution in original post

6 REPLIES 6

Chalan B L
Giga Guru

Hello David,

 

There are 5/6 schedule jobs which runs daily, is it running daily ??

Please do checkout this video to understand on how the CMDB Dashboard works

CMDB Dashboard

Also find the attacment it will help you..!!

 

Mark the answer as correct and helpful if it helped you..!!

 

Regards,

Chalan

David Anderson2
Kilo Expert

There are 5/6 schedule jobs which runs daily, is it running daily ??
I manually executed each job (execute now).

I have watched the attachment and reviewed Community, Product Documentation, and I have scoured the web looking for help.  I do not understand why the CMDB Query and the CMDB Group both produce the expected result (four distinct applications in my example), but the CMDB Group Health dashboard based on the CMDB Group is not returning non-zero values.

Try clearing cache ,this was a earlier bug

 

Regards,

Pranav

Mark my Responses as Correct and Helpful if you find it relevant.

 

David Anderson2
Kilo Expert

I don't think it is a cache issue as I have queried the CMDB Health Scorecard table and found:

find_real_file.png

The numbers for failed (0) are related to the most recent execution (updated).