Icon
Join thousands of Atlassian users for an unforgettable week of knowledge sharing, product training, networking, and fun. Atlassian Summit is Oct 10 - 13 in San Jose, CA – Register soon before tickets sell out.
Icon
Maintenance Notice: answers.atlassian.com will undergo maintenance on 24 Sep 2016, from 22:00 - 07:00 UTC. During this maintenance window, the service may be intermittently unavailable. See our status page for details.
 
1
0
-1

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
    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      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'
      


        CommentAdd your comment...