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,
cd.directory_name,
li.SUCCESSDATE
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 = cd.id
ORDER BY SUCCESSDATE;

 

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

Hi,

It seems that this information is no stored in Confluence

https://community.atlassian.com/t5/Confluence-questions/User-login-information/qaq-p/419474

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events