SQL Query help: Select all users with the assigned user groups

[Annika Wagner]

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 :) 

[Tansu Akdeniz]

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/

[Annika Wagner]

Hi Tansu,

thank you for the links.

Best Regards,

Annika 

[Josh Steckler]

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 

[Annika Wagner]

Hi Josh,

thank you for your quick reply. Your sql-script works very fine.

Best Regards,

Annika