Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Meital Adir
Contributor
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 Champion
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