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

Question

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

Annika Wagner · Answer

Hi Tansu,

thank you for the links.

Best Regards,

Annika

Annika Wagner · Answer

Hi Josh,

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

Best Regards,

Annika

Josh Steckler · Answer

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