The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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 @joaquin_nunez ,
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
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.
Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋♀️ ...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.