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!
Hi,
It seems that this information is no stored in Confluence
https://community.atlassian.com/t5/Confluence-questions/User-login-information/qaq-p/419474
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.