Reports on Incident and SCTask Tickets worked on by a Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 07:49 PM
Hello All,
I am looking to pull a report on Incident tickets and SCTask tickets that were worked on by a group (lets call the Group "Benefit") however, I do not want to include tickets that was assigned to the group but not worked on by a member of the group (meaning the ticket was reassigned to the appropriate group). I only want to pull tickets worked on by group "Benefit" (or simply a member of group "Benefit").
Is there a way to pull these reports without scripting? If scripting is required, could you help with a script if you've worked on a similar report or know how to get this done?
Your help is appreciated.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2020 03:06 PM
Hello. I tried this but its not pulling the right number for incidents and ritm assigned to the group at a point, worked on (briefly) and reassigned to another group. Its only pulling tickets assigned to the group and closed by the group.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-19-2020 08:27 PM
Create new report Give appropriate name to it.Under source type select the table and give table name under table field.
Select the visualization type.
Under configure select the group by as assignment group.
Thanks,
Dhananjay.