Reporting Incidents Closed by Members of a Group

[ksonnemann]

How in a a report can I get all incidents closed by members of a certain assignment group?

Where closed_by equals a member of the group?

[david_legrand]

Hi,

This requirement won't have very elegant solutions, but I can see 2 options:

1. If your data "membership" aren't volatile for the time frame of the report:
   1. OK: "My memberships could change over the year but I'm interested by the data of the last week"
   2. NOK: "My memberships could change over the week but I'm interested by the data of the last year"
   3. In that case, you could make a database view between the incident table and the membership and group tables
2. If your data "membership" are volatile for the time frame of the report:
   1. You need to archive the data on the incident form using some rules
   2. Don't forget you'll have a list of groups who will close the "incident"
3. The 3rd way (But I never tested it yet, so i don't consider that as an option) could be using the http://wiki.servicenow.com/index.php?title=Using_Filters_and_Breadcrumbs#Dublin but I don't guarantee anything as the dynamic filters seem to use the current logged user.

If I have to do it, even if the solution will have some limitation (and is definitively not elegant), I'll choose the 2nd option because I generally care about the "stability" of the data.

Regards,

[randrews]

I just found a global BR called report helper that contains a function that will do the job for you...

getAllMembersOfMyGroups()

what i find to be REALLY kewl is   you can create a closed by report from this... so select for example task table.. group it by closed by and stack the task type... for closed by put in javascript:getAllMembersOfMyGroups()       and for created put in on this month...

Viola anyone looking at it sees all tasks closed by their groups for the current month on a bar chart by person with stacked task types.... how kewl is that!?