How to get the user login count from confluence DB (SQL)

Meital Adir January 11, 2023

I need help with getting the users login count in confluence, to check the usage. 

I have the SQL query to find the users list and last login date, 

can anyone assist with adding to it the login count for each user? 

SELECT cu.user_name,
FROM logininfo li
JOIN user_mapping um ON um.user_key = li.USERNAME
JOIN cwd_user cu ON um.username = cu.user_name
JOIN cwd_directory cd ON cu.directory_id =


Thanks in advance!


1 answer

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 11, 2023


It seems that this information is no stored in Confluence

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events