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;