How do you identify disabled/deactivated users group membership?

Karen_Mustain October 8, 2019

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?

1 answer

1 accepted

0 votes
Answer accepted
Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 8, 2019

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'
Karen_Mustain October 8, 2019

Thanks Davin, I will give that a try!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events