Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,516
Community Members
 
Community Events
165
Community Groups

Export usernames belonging to the same group in Crowd

does anyone has a SQL handy to run and get a list of users belonging to the same group?
thanks in advance

  • potentially span across directories
  • get their emails, etc as well

1 answer

1 accepted

1 vote
Answer accepted

SELECT DISTINCT u.first_name, u.last_name, u.email_address, u.user_name
FROM `cwd_membership` m
INNER JOIN `cwd_user` u ON m.child_id = u.id
WHERE `parent_id` 
IN (

SELECT id
FROM `cwd_group` 
WHERE group_name LIKE 'ABC%'
)
AND membership_type LIKE 'GROUP_USER'


Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

📅 Partner Webinar & Events Opportunities: July 2022

Hi community 👋, Here is another monthly roundup of the partner-organized events in July 2022. If there is any event missing please let me know in the comments below 🙏 If you're looking for Atla...

29 views 0 2
Read article

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