Confluence Data Center sql query Oracle to fetch all users and Lat Login

Fidelidade JIRA Admin October 7, 2024

Good afternoon team,

Can anyone tell me what the query is to get all Comfluence users and their last login?

 

Thank you,

BR

Emanuel

1 answer

0 votes
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 7, 2024

Hi @Fidelidade JIRA Admin 

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

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.5.4
TAGS
AUG Leaders

Atlassian Community Events