confluence login

List of Users who Logged in Successfully to Confluence after 19th January 2017

SELECT u.user_name, d.directory_name, l.successdate
FROM logininfo l
JOIN user_mapping m ON m.user_key = l.username
JOIN cwd_user u ON m.username = u.user_name
JOIN cwd_directory d ON u.directory_id = d.id
WHERE successdate > '2017-01-19'
ORDER BY successdate;

 

  Total Number of Users who Logged in Successfully to Confluence after 19th January 2017
 

 
  
SELECT COUNT(u.user_name)
FROM logininfo l
JOIN user_mapping m ON m.user_key = l.username
JOIN cwd_user u ON m.username = u.user_name
JOIN cwd_directory d ON u.directory_id = d.id
WHERE successdate > '2017-01-19'