Good afternoon team,
Can anyone tell me what the query is to get all Comfluence users and their last login?
Thank you,
BR
Emanuel
You can give a try with the below SQL:
SELECT
um.username,
um.display_name,
um.email_address,
TO_CHAR(um.created_date, 'YYYY-MM-DD HH24:MI:SS') AS created_date, TO_CHAR(MAX(ls.lastlogindate), 'YYYY-MM-DD HH24:MI:SS') AS
last_login_date
FROM
user_mapping um
LEFT JOIN
logininfo ls ON um.user_key = ls.username
WHERE
um.active = 1
GROUP BY
um.username, um.display_name, um.email_address, um.created_date
ORDER BY
last_login_date DESC NULLS LAST
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.