Confluence spacename and groupnames including group members query

[Rudy Torres]

Hello All,

I am in search of a query that will list all spacenames including groups, and users from each group.  I have a query that lists spacenames and groups with permissions to the space, but am lacking the members of the group.  I think I need to add a join to (cwd_membership/cwd_user?) on the crowd database to get the members of the groups, but do not have the join criteria nailed down.  Here is what I have for listing spacename and groups:

SELECT S.SPACENAME,
PERMGROUPNAME AS GROUPNAME,
PERMTYPE AS "PERMISSION_TYPE (SPACE)"
FROM SPACEPERMISSIONS SP
JOIN SPACES S ON SP.SPACEID = S.SPACEID
WHERE PERMGROUPNAME IS NOT NULL
ORDER BY S.SPACENAME,
PERMGROUPNAME,
PERMTYPE;