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)
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
Hi Srinatha T
Thanks for the answer. I will check (access to Database)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Joaquín Núñez , sure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.