Performance Analytics for total open tickets for a specific Configuration Item?

[MBarrott]

I'm not sure if this is already available OOTB but a request I recently had was the following:

"I want to see the total number of open tickets for security vulnerabilities"

Security Vulnerability is a CI we have. 

I know we have an indicator called "Number of open tickets" and there is Configuration Item breakdown but I'm unable to select it as an available breakdown. I don't believe it is tied to any indicators.  

Is this an achievable ask or would I need to start tracking that data moving forward? 

[MBarrott · Accepted solution]

Resolved myself. 

- did not find a OOTB PA Widget that tracked this with accurate indicators or breakdowns. Modified pre-existing indicator to also track Config Items. Created new Breakdown record for Configuration Items and mapped to task table - cmdb_ci field. Set Widget breakdown element to the necessary Ci.