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?

[Chuck Tomasi]

Hi Heidi,

You can do this by reporting on the group membership table (sys_user_grmember). It contains all the groups and users in that groups.

[heidiyablonski]

Hi Chuck,

I don't have a sys_user_grmember field. Do you know what I'm doing wrong or have any other suggestions?

[shloke04]

Hi,

As chuck said above, you need to pull a report on Group member Table(sys_user_grmember) where you can get all the Group and User details as shown below:

Hope this helps. Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[Chuck Tomasi]

Here's a way to get a report on a table that doesn't normally show up on the table field of a report... Go to the table list first.

From there, right click the header and create either a bar chart or pie chart.

Modify the report details from there.