Good afternoon,
I am looking for a bit of help to write a SQL query which will select all users with the assigned user groups.
Any help would be appreciated :)
Hi @Annika Wagner,
Please check the queries described in this link.
Also Jira db tables doc can help you further: https://developer.atlassian.com/server/jira/platform/database-user-and-group-tables/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Annika,
Here's an example that works with MySQL:
select cwd_user.user_name, cwd_user.display_name, cwd_user.email_address, GROUP_CONCAT(cwd_membership.parent_name SEPARATOR ', ') as "MemberOf" from cwd_user inner join cwd_membership on cwd_membership.child_id = cwd_user.ID where cwd_membership.membership_type = "GROUP_USER" group by cwd_user.user_name, cwd_user.display_name, cwd_user.email_address
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Josh,
thank you for your quick reply. Your sql-script works very fine.
Best Regards,
Annika
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.