Create a report of groups that includes all group members

[heidiyablonski]

I'm beand new to SN so please be patient (we arent even live yet).     I'm being asked to create a report of all assignment groups and include the assignment group members.   I haven't been able to get a report of the groups and include the group members.   How can I do this?

[LRadtke]

Hi @Chuck Tomasi, I have seen a lot of people telling me to use the Group Membership(sys_user_grmember) table for this, however, I am seeing a couple of issues with it:

1. Does not actually show all of the groups
2. Does not show groups that do not have members
3. Just like everyone else, (empty) groups, which I understand is an issue on the sys_user_group table

I need to be able to run the report to show all groups and their members...meaning if there is a group with no members, I need to see that too. I have not been successful yet in doing so.

Any advice?

[Roso Rosomak]

I have stumbled on this just today, searching for the same. 
That report seemed to be fine, but did NOT shown me all owners of filtered (by conditions) groups.
I have used Pivot output (group / users). Have seen list but that one was not good for export ... yes ... manual export as ServiceNow did not gave me the possibility to export results directly to excel so I had to export it to PDF, make a selection and from there to excel manually.

[heidiyablonski]

Thank you so much!   I forgot about the .list

[Chuck Tomasi]

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you

[heidiyablonski]

perfect! thank you.