In our Confluence instance we disable associate user accounts when an associate has left the company. However, that disabled user is not removed from all confluence security groups.
Does anyone have a script that will identify deactivated users and their corresponding security user group membership?
This SQL query should get you inactive users and their group membership.
select U.[user_name], U.display_name, G.group_name
from cwd_user U
inner join cwd_membership M on U.id = M.child_user_id
inner join cwd_group G on M.parent_id = G.id
where U.active = 'F'
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.