Performance Analytics - Breakdown on child class

[Blair5]

I have a requirement to breakdown on a child table. I have my indicators built on the incident table and need to break down by a field on the application table. The incident table references the CMDB_CI table and the field I need is on the CMDB_CI_APPL table. I understand that a script is necessary but which table do I write this script to and what field? How do I map it to the breakdown source? Very new to PA and trying to learn as much as I can. Thank you in advance for you help.

[Adam Stout]

I think you need to setup a breakdown sandwich.   I'm not aware of a table that holds all the classes so you would need to materialize that as a manual breakdown.   Then you can run a script to associate the records with the manual breakdown.

[Blair5]

Hi Adam,

Not sure what a breakdown sandwich is? Typo maybe. I'm not trying to get to the class, but a field on a child table of the cmdb_ci table. Could you explain it a bit more?

[Adam Stout · Accepted solution]

Ahh.. Sorry.   You need the field that is not available to select in the breakdown mapping configuration, correct?

If that is the case, you don't need a script, you just need to find the field name and list edit the breakdown mapping to enter the field name.

1) Go to the list view for incident (or whatever the indicator is on)

2) Use the condition builder to select the field you want.

3) Click on the breadcrumbs and copy the query.   This will give you the fully qualified name of the field (it should start with a "ref_")

4) Configure a breakdown mapping for any field on the cmdb_ci field

5) List edit the breakdown mapping and replace the field with the fully qualified field you got in step 3.

That should get you what you want.

[Blair5]

Adam,

I am so sorry that I never responded. This worked like a charm. Unfortunately, the requirement is to go another level from the last field. It's not directly related in any way I can see but this helps a ton! Thanks again