How to identify unused confluence group and groups and associated space name.
Hey @Jayakumar Narayanamoorthy,
You can use the SQL query below to identify the group(s) with no members:
select g.group_name, count(g.group_name) AS total_members from cwd_user u
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
where d.directory_name='Confluence Internal Directory'
group by g.group_name
order by count(g.group_name) asc;
and then, you can find the space they are associated to (in terms of permission) by the queries outlined in the KB below:
https://confluence.atlassian.com/confkb/how-to-list-which-spaces-a-group-can-access-720636535.html
Hope this helps :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.