Home » Forums » Symantec Products and Technologies » Helpdesk Solution

Count for Linked Incidents

Count for Linked Incidents
Submitted by acachero on 31 July, 2008 - 23:47.

Can someone please assist me in creating a report to Count the number of incidents linked to a master case?

EG - How many incidents are in the 'Linked By' field to a specific ticket.

Thanks

Don't know if you've found an answer yet!

Submitted by NormalC on 7 August, 2008 - 11:00.

I listed the number of the helpdesk ticket and the count of the child tickets in this simple query. Hope this helps...

SELECT hd1.workitem_link_parent_number AS Parent,   Count(hd1.workitem_number) AS [Count of Children]  
FROM dbo.HD_workitem_current_view AS hd1   
WHERE NOT(hd1.workitem_link_parent_number = 0)  
GROUP BY hd1.workitem_link_parent_number  
ORDER BY hd1.workitem_link_parent_number

Thank you for your reply

Submitted by acachero on 7 August, 2008 - 19:24.

Thank you for your reply NormalC
This is exactly what i'm after.

You're Welcome

Submitted by NormalC on 8 August, 2008 - 11:53.

Glad I could help.

Syndicate content