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

Question

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!

Mohamed Benziane · Answer

Hi,

It seems that this information is no stored in Confluence

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