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!!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did your comment get deleted ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Indeed... You're welcome !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.