Reporting with Members of a Group

Maria20 · ‎05-09-2018

I created a report off the Task table to get all open tickets.

I want to include all tickets that have been assigned to members of certain groups. The Assignment Group field is not consistently filled in so I have to rely on whether the Assigned To value is a member of the group.

I've tried dot walking but with no success. Any ideas?

Gaurav Bajaj · ‎05-09-2018

Hi,

You can create a dynamic filter to check that the user (assigned to) is part of that specific group or not.

This would need a script include, a dynamic filter option and you can use it as a filter on your task table.

Let me know if you need help with the script.

https://www.servicenowguru.com/system-definition/harnessing-power-dynamic-filters-servicenow/

This link has a great example of the same objective.

Please mark it correct/helpful based on the response.

Thanks
Gaurav

View solution in original post

Kevin Loenker · ‎05-09-2018

To go along with what Gaurav Bajaj said, I use the following dynamic filter in my reports. According to my admin this one is OOB.

javascript:getGroupMembers('Group1','Group2','Group3','Group4','Group5')

Use that in the Assigned To field with the IS operator (the text field will bawk at you as if it's invalid, ignore that)

Maria20 · ‎05-10-2018

Hello Kevin,

In true ServiceNow form, there is more than one way to resolve my issue.

This solution worked seamlessly and got me the results I was looking for!

Thank-you so much!

Maria.

Amanda Buggy · ‎01-28-2020

We should all up vote this idea so can be done OOTB

Easy way to identify group membership from sys_user table