Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Generating a List of User Names by Group

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?

2 answers

Hello Camden,

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.

Cheers,

Guilherme

For just one group

select DISTINCT u.lower_user_name, 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
where g.group_name = 'mygroup'
order by g.group_name;
0 votes

Tweaking Guilherme's sql query to add extra info of username, first and last name:

select u.user_name, u.first_name, u.last_name, 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;

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,583 views 7 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you