Reporting on Incident Opened by a Member of a Group?

[spaceyjacey]

We have many members of each group and we want a report on all incidents opened by members of a particular group. The only way we are able to run the report is to filter:

"Opened by - is - Brian - OR Opened by - is - Craig - OR Opened by - is - Alex - OR and so on..."

Is there a way to filter "Opened by - is - a member of 'Service Desk'?"

[C_Hick]

i've got it working!   Thanks for the update.

[kdevireddy]

Thanks RV,This helped me.

Just I want to add my experience.

This works if analyst who is running report has itil role.(OOB)

For custom role - User who is running this report should have read access to 'sys_user_grmember'

Thanks,

Kiran

[mollyclark7]

You could also create an individual role for each group (e.g. service_desk), or only for groups you care to report on specifically, apply it to all members of the group, and filter by users with that role.

[Alan Norris]

Thanks All,

This is really useful.

Created a Script Include using the above and was then able to add it as a Dynamic filter option.

[Thais Pulliam2]

how did you build that?

thanks!