How to know which spaces are allowed to visit by user or group easily?

Question

We have similar groups maybe duplicating access to some spaces.

I would like to clean and unify groups but I do not know how which spaces are related to each group.

Is there any option to see easily?

EX. Group xxxxxx: permission access to spaces...... (lis of spaces)

Srinatha Tondihal · Answer

@Joaquín Núñez , sure.

Joaquín Núñez_6pzswy · Answer

Hi Srinatha T

Thanks for the answer. I will check (access to Database)

Srinatha Tondihal · Answer

Hi @Joaquín Núñez , Welcome to Atlassian community. I hope you have the access to Database. If you have then you can run the following query to fetch group permissions on spaces. 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 != '' I hope the info helps. Have a good day. Thanks, Srinath T