CMDB Health Calculation

Tim McCarthy
Tera Contributor

‎03-02-2020 08:12 AM

Hey guys,

We need the ability to trend the CMDB Health scores.  I'm having a hard time reconciling the denominator in the health calculations.  The only one I was able to line up was the denominator in the duplicate calculation.  Where are these numbers coming from?  Any help is appreciated.

find_real_file.png

  

Labels:
Preview file
66 KB
Preview file
20 KB
0 Helpfuls
  • 3,096 Views
5 REPLIES 5

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎03-02-2020 08:51 AM

These come from the CMDB Health tables.  I believe there are indicators for this in "Performance Analytics - Content Pack - Configuration Management (CMDB)".  Specifically, you should see the Indicator Source "CMDB.Health.Scorecard"

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/use/dashboards/application-conte...

0 Helpfuls

Tim McCarthy
Tera Contributor

‎03-02-2020 11:59 AM

Hi Adam,

Thanks for the response.  I might be incorrect, but this is what I've been able to discover so far.  The widgets on CMDB View are based on the cmdb_health_result table.  This table gets populated via jobs that run daily and execute scripts.

Jobs (we have 3 of the 5 jobs active):

  • CMDB Health Dashboard - Completeness Score Calculation
  • CMDB Health Dashboard - Correctness Score Calculation
  • CMDB Health Dashboard - Relationship Score Calculation

Scripts:

  •  SNC.MetricProcessorScript.completenessManager();
  •  SNC.MetricProcessorScript.correctnessManager();
  •  SNC.MetricProcessorScript.relationProcessor();

The record counts from the cmdb_health_result table line up with the numerator in the metric calculations.

There is a formula indicator named CMDB Health Results - breakdown that has the following calculation:

  • ([[CMDB Health Results]]/{{Number of Configuration Items}}) * 100

I don't think the above formula indicator is the one utilized in CMDB View.  We haven't had scores for this indicator since November.  My best guess is this was utilized for the depreciated CMDB Dashboard.

Unfortunately, I have not been able to find a way to access the widgets utilized in CMDB View to see exactly what they are doing.

My best guess so far is that total number is being determined somehow based on the health inclusion rules that are saved in the cmdb_health_config table. However, when I run a report on the cmdb_ci table utilizing the health inclusion criteria, the totals don't seem to line up either.

0 Helpfuls

Adam Stout
ServiceNow Employee
ServiceNow Employee
In response to Tim McCarthy

‎03-02-2020 02:42 PM

Is that indicator in the CMDB content pack or in Benchmarks?  Not following breakdowns on Number of Configuration Items seems very odd.

0 Helpfuls

Tim McCarthy
Tera Contributor
In response to Adam Stout

‎03-03-2020 08:07 AM

It looks like the CMDB Health Results - breakdown is part of the Performance Analytics - Content Pack - Configuration Management (CMDB) plugin.

I found three JavaScript widgets that I think are what's being displayed on CMDB View:

  • CMDB Widgets
  • CMDB Service Widgets
  • CMDB Group Widgets

The above three widgets are all part of the Configuration Management (CMDB) package.  When I paste in the one of the urls from these widgets, IE "/$cmdb_scorecard.do?sysparm_type=completeness" from CMDB Group Widgets, I get brought to the same objects that are on CMDB View. 

I'm not well versed in JavaScript, so if I'm right and these are being utilized to populate CMDB View, any help in deciphering them would be greatly appreciated.

0 Helpfuls