does anyone has a SQL handy to run and get a list of users belonging to the same group?
thanks in advance
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'
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
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