Find Questions…

Close ×
First time here? Check out the FAQ!

Export usernames belonging to the same group in Crowd

Andrei asked this question · 1,916 karma ·

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
442 views

One Answer:

Andrei · 1,916 karma ·

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'


Looking for something else?

Find Questions…

or Browse other questions tagged:

or Ask a Question