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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For faster reference, the MySQL code is:
SELECT u.*
FROM cwd_user u
JOIN cwd_membership m ON m.child_user_id = u.id
JOIN cwd_group g ON m.parent_id = g.id
WHERE g.group_name = 'GROUP_NAME_TO_CONSIDER'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Because you may want to list the users of confluence-users and have 15.000 of them ;-).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.