Reporting creation

[pramn]

Hi Members, 

Greetings! 

We are required to create reports. 

 In the CMDB health dashboard, we have an overall score, which is a combination of completeness, compliance, and correctness.

Requirement: The user wants to populate the overall score based on the CMDB group.

Can't find the overall score stores in which table; also find there is a script included running to populate the overall score. 

getOverAllScore: function(completeness, correctness, compliance) {
var weightedScore = 0;
weightedScore = this. _getParentMetricScore(completeness,weights) + this._getParentMetricScore(correctness,this.weights) + this._getParentMetricScore(compliance,this.weights);
return weightedScore;
},

I am not sure how we can create the reports. Any thought and suggestion toward the creation of the report is most welcome.

[Me Being Mustaq]

Hi @pramn ,

The CMDB Health overall score in ServiceNow is a computed metric rather than a field stored directly in a table. It combines completeness, correctness, and compliance metrics using scripted weights and functions like the getOverAllScore method you referenced. Typically, these scores are calculated dynamically by scripts during dashboard rendering or via scheduled jobs

• The overall CMDB Health Score itself is generally not stored persistently as a single field in a database table.

• The component scores (completeness, correctness, compliance) are calculated based on data in CMDB CI tables and related metric tables (e.g., cmdb_metric_base or cmdb_metric_score).

• The calculation script you found usually aggregates data and applies weighting to produce a score on the fly or during scheduled processing.

Creating Reports for Overall Score by CMDB Group

1. Use or Create a Table to Store Group Scores

2. Leverage Existing CMDB Metric Tables

3. Use Performance Analytics

4. Custom Report Using Scripted Dataset

Example Report Creation Steps

1. Identify/configure the grouping field (e.g., cmdb_group or custom grouping).

2. Create a scheduled job or business rule to calculate and store overall scores per group.

3. Build a report on the custom score table grouped by CMDB Group.

4. Use UI Reporting or Performance Analytics to visualize.

Since the overall score is calculated (not stored), you must either precompute and store group-level scores or use dynamic scripted reporting. Starting with a small proof of concept for one or two CMDB groups can help confirm approach and performance before scaling.

If it is helpful, please hit the thumbs button and accept the correct solution by referring to this solution in the future it will be helpful to them.

Thanks & Regards,

Mohammed Mustaq Shaik