Home Advanced Request Offering

How to see number of Incidents linked to a Problem record

Tina_SamsTina_Sams Customer IT Monkey ✭

Hello,

A colleague is trying to create some dashboards and we need one for Problem Management. We would like to be able to show a count of how many Incidents are linked to a Problem record but he can't see how to do this. Any suggestions gratefully received.

Thank you.

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    @Tina_Sams - This may not be all of what you're looking for, but may be a start. This SQL query will show the PR ID and the count of work items related to it. You could build a SQL Table Widget on a dashboard page with this query to show at least a part of what you're wanting.

    SELECT 

    pr.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C as 'WorkItemId', 

    count(*) as 'COUNT' 

    FROM MTV_System$WorkItem$Problem pr

    JOIN Relationship r

    ON r.SourceEntityId = pr.BaseManagedEntityId

    AND r.RelationshipTypeId = 'cb6ce813-ea8d-094d-ee5a-b755701f4547' --System.WorkItemRelatesToWorkItem

    GROUP BY pr.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C

  • Tina_SamsTina_Sams Customer IT Monkey ✭

    Thanks Justin, I'll pass the information on.

Sign In or Register to comment.