Get groups permission report excluding archived and personal spaces via SQL database
Platform Notice: Cloud Only - This article only applies to Atlassian apps on the cloud platform.
Summary
List all groups usage in our confluence spaces, but exclude personal spaces and archived spaces
Environment
confluence cloud
Solution
In order to list the usage of all the group excluding personal and archived spaces, please use the below SQL from the tenants instance database for the report:
select s.spacekey, s.spacename, sp.permtype AS "Permission", sp.permgroupname AS "Group"
from spacepermissions sp
JOIN spaces s on sp.spaceid = s.spaceid
WHERE sp.spaceid in (select spaceid from spaces)
and sp.permgroupname is not null
and sp.permgroupname != ''
and s.spacetype != 'personal'
and s.spacestatus = 'CURRENT' Updated on April 21, 2026
Was this helpful?
Still need help?
The Atlassian Community is here for you.