How to identify unused confluence group and groups and associated space name.

[Jayakumar Narayanamoorthy]

How to identify unused confluence group and groups and associated space name.

[Lauretha Rura]

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 :)