How to find all inactive and active users count in Confluence Datacenter

kanaka prasad ponnuru October 27, 2022

Hi Team,

We have recently migrated LDAP post migration in jira they were 2700 user impacted. That means 2700 users were deleted and created but after user creation these 2700 users were removed from groups (jira-softwere-users). Manually we have added tbe users into above group.

We get this data from audit log in jira but when we search the same in Confluence we are not getting appropriate count.

Can someone help me how to get the active and inactive users count?



1 answer

0 votes
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 28, 2022


Jira is more admin friendly in this regard.

You have to execute a SQL-Query, if you want to filter inactive confluence users.

Please check this article: Solved: Find inactive users in Confluence (


Kind regards 


Kinza Kinzakhan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 18, 2024

Schools utilize software for various administrative and educational purposes, such as managing student records, scheduling classes, facilitating communication, and delivering instructional content, enhancing efficiency and organization in school operations.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events