How do you identify disabled/deactivated users group membership?

Question

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?

Davin Studer · Accepted Answer

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'