We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Performance Analytics vs Custom Table for CMDB Data Quality Reporting (400k+ CIs)

HarikrishnaR199
Tera Contributor

3 weeks ago

Hi  @everyone,

We have a CMDB with approximately 400k+ CIs and need to build data quality reports (missing attributes, completeness, etc.).

For an environment of this size, what is the recommended approach?

  • Use Performance Analytics (automated indicators/KPIs), or
  • Calculate the metrics and store the results in a custom table for reporting
  • 412 Views
1 REPLY 1

Hanna_G
Kilo Sage

2 weeks ago

Hi there, 

 

I'd recommend using the out of the box CMDB health functionality: CMDB Health • Australia ServiceNow AI Platform Capabilities • Docs | ServiceNow
From there you can see reporting capabilities. The metrics you mention on attributes and completeness can also be configured so the reporting is accurate. Tasks can also be generated when CI health isn't where you've set the governance to be for remediation. 

Here are some more supporting articles: 
CMDB Health Dashboard – Best Practices and FAQs - ServiceNow Community
Understanding CMDB Health - ServiceNow Community

0 Helpfuls