Export usernames belonging to the same group in Crowd

Andrei [errno]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2012

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
Andrei [errno]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2012

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
AUG Leaders

Atlassian Community Events