To get Group membership details you can use table called cwd_membership
To get user belongs to which all groups
Select * from cwd_membership where child_name = 'user_name'
To get list of users in particular groups
select USER_NAME, DISPLAY_NAME, EMAIL_ADDRESS from cwd_user
where lower_user_name in (select child_name from cwd_membership where parent_name = 'group_name')
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG