How To list members of a Group in a Report

[Andrew Payze]

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

[Allen Andreas · Accepted solution]

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

[Andrew Payze]

Thank you guys, this was what I was looking for

Andrew

[ITProMD]

Thank you very, very much. This was super helpful to a recent customer.

[Rahul Shandily3]

User and Group reside in the table sys_user_grmember. It has the exact data that you may be looking for.