I want to look up users in the database that belong to a certain group i.e. "space-managers"
If you're using internal accounts, you'll need to join cwd_membership to cwd_user to find a (human) list of people in a group. And cwd_group to see the human names of the groups.
Thanks for answering! Would you be able to write out the SQL? We are using a MySQL instance.
select * from cwd_membership join cwd_user on cwd_membership.child_user_id = cwd_user.id;
Is the raw starting point in postgres (should translate to MySQL without any fuss). You probably want to add a second join on cwd_group if you want the group names too.
Why do you want to query the database when the information is available in Confluence, see https://community.atlassian.com/t5/Confluence-questions/How-do-I-view-a-list-of-confluence-administrators/qaq-p/1767470?
Because you may want to list the users of confluence-users and have 15.000 of them ;-).
For faster reference, the MySQL code is:
SELECT u.*FROM cwd_user uJOIN cwd_membership m ON m.child_user_id = u.idJOIN cwd_group g ON m.parent_id = g.idWHERE g.group_name = 'GROUP_NAME_TO_CONSIDER'
It looks like you're new here. Sign in or register to get started.
