Reports on Incident and SCTask Tickets worked on by a Group

[AP30]

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

[AP30]

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.

[Dhananjay Pawar]

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.