Problem Definition

Currently, to view group membership in Bamboo, we need to query the database instead of viewing this in Bamboo as we can with other products. This applies to instances using internal user management.

Suggested Solution

Add a page under Admin >> Groups to view group membership.

Workaround

The following SQL query can pull group membership from the Bamboo database:

SELECT name, email, fullname 
FROM users u 
JOIN local_members l 
    ON u.id = l.userid 
JOIN groups g 
    ON l.groupid = g.id 
WHERE g.groupname = '<group-name>';
-- replace <group-name> above with the group you are querying