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 · Accepted solution]

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

[Iro Karavasili]

Thank you @Antoine Berry !! :)

[Antoine Berry]

@Iro Karavasili ,

did your comment get deleted ?

[Iro Karavasili]

@Antoine Berry  Hmm yes, strange... :/ 
I just wanted to thank you! :P

[Antoine Berry]

Indeed... You're welcome !