How To list members of a Group in a Report

Andrew Payze
Kilo Guru

I am trying to build a report that lists the members of a Group.  

I tired using the sys_user_group table and then seeing if there was a related list to the sys_user table but that did not seem to be an option.  I did try in reverse.

Is there a way to Group Users by Group they are a member of.   If they are in more than one group the user would appear more than once.    I would be OK to group by User and list their groups

Tx

Andrew

1 ACCEPTED SOLUTION

Allen Andreas
Administrator
Administrator

You need to report on the table Group Members (sys_user_grmember)


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

5 REPLIES 5

Ash Goswami
Tera Contributor

I need to build a report for multiple users with their assignment groups. Sys_user_grmember is not helpful. Can you please suggest another option