Export usernames belonging to the same group in Crowd

[Andrei [errno]]

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

[Andrei [errno] · Accepted solution]

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'