I would like to generate a list of User Names by their Confluence Group Membership. I want to use this list to send email alerts to the users for maintenance outages, etc. Is there a way to do this within Confluence, or can you provide a SQL query that I could use to get it directly from the database?
You have either two options, to go to your Group Browser, and there have a list, but you still need to click next if there is lots of users. Or you can use the following query who will have the users by Group :)
select u.lower_email_address,g.group_name from cwd_user u inner join cwd_membership m on u.id=m.child_user_id inner join cwd_group g on g.id=m.parent_id order by g.group_name;
Hope this helps you, also I have made the query to select only emails and group names.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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