Performane Analytics report on Class Info Table.c

[Ashish Purwar]

I want to create a report showing count of CI's in each class (Class Display Name) form Class Info Table (u_class_info). I am using the same table in Indicators and Breakdown sources, however it is not showing the desired results, instead it is only showing the counts of records (rows) which are there in the table. 

Please suggest. 

[HaimNizri]

The issue you're running into is pretty common with PA - you're getting record counts from the Class Info table itself instead of actual CI counts per class.

What you really need is to point your data source at the actual CI tables, not the Class Info table. The Class Info table just holds metadata about the classes - it doesn't contain the CIs themselves.

Try this approach instead:

Set up your indicator with the Configuration Item [cmdb_ci] table as your data source. This is the base table that all CI classes extend from. Then for your breakdown, use the "Class" field (sys_class_name) - this will give you the technical class names.

If you specifically need the display names from your u_class_info table, you can create a transform map or use a calculated field that does a lookup between sys_class_name and your custom table.

Another option is to use the out-of-box "Tables" breakdown source on the cmdb_ci table, but that might give you more granular results than you want.

The key thing to remember is that PA counts records from whatever table you point it at. Since u_class_info probably has one record per class definition, you're just getting a count of how many class definitions exist, not how many CIs are in each class.

Let me know if you want me to walk through the indicator setup - the data source piece is usually where people get tripped up with this kind of report.

[SohamTipnis]

Hi @Ashish Purwar,

It looks like the indicator is currently counting the records in the u_class_info table, which is why you're only seeing the number of rows from that table instead of the number of CIs per class.

To get the correct result, the indicator source should be based on the CI table (cmdb_ci), since that’s where the actual CI records exist. Then you can use Class Display Name (or sys_class_name) as the breakdown so the data gets grouped by class.

Right now, because both the indicator and breakdown source are using u_class_info, the system is just counting those records rather than counting the CIs belonging to each class.

Use Class Display Name / sys_class_name as the breakdown

This will show the count of CIs for each class, which should give you the result you're looking for.

If you find my answer useful, please mark it as Helpful and Correct. ‌‌‌‌‌‌‌😊

Regards,
Soham Tipnis
ServiceNow Developer ||  Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10