Jira mySQL query: Active users that belong to a specific group

Iro Karavasili

Hi all!

I'm trying to find a mySQL query that returns all the active Jira users that belong to a specific group.
We use jira version 7.9.2.
Any help would be useful!

Thank you!!

Antoine Berry

Hi @Iro Karavasili ,

Kindly try : 

SELECT DISTINCT 
cwd_user.lower_user_name, cwd_user.display_name
FROM cwd_user 
JOIN cwd_membership ON cwd_membership.child_id = cwd_user.id
JOIN cwd_group on cwd_membership.parent_id = cwd_group.id
WHERE cwd_group.group_name = 'your-group'
AND cwd_user.active = 1

Antoine