SQL request Skip to main content
https://support.okta.com/help/answers?id=9062a000000xancqa0&refurl=http%3a%2f%2fsupport.okta.com%2fhelp%2fanswers
How satisfied are you with the Okta Help Center?
Thank you for your feedback!
How satisfied are you with the Okta Help Center?
1
2
3
4
5
Very Dissatisfied
Very satisfied
Enter content less than 200 characters.
Ask Search:
arnold godinarnold godin 

SQL request

Hi teams,
Currently, I meet a problematic with the OKta SSO on one of our application : Confluence (Altalssian product)
We need to make reports which contains the value : last authenticated users to Confluence, we get the correct values but only when users don't use SSO OKTA (standard authentification). But I can't have the correct values for all users using OKTA.
I used a SQL request (mysql) to get this information within the Confluence Database. It's probably logic because the OKTA values are not in our database but do you know a way to get these informations : Last authenticated users values with Okta? May be in Okta report...
Thanks in advance for your help.
Arnold Godin
Best Answer chosen by Dylann Fezeu (Customer First Programs)
Stefan PescaruStefan Pescaru (Okta, Inc.)
Hello Arnold, 

You can view the last login of your users within a specific application, by following the path Okta Admin Dashboard > Reports > Reports > Application Usage.
There, please select the filters (application, users,timeframe) accordingly, and run the report. The last column in the result table will contain the timestamp of your users' last login within the app. This report can also be exported as a .CSV.

Thank You,

Stefan Pescaru
Technical Support Engineer
Okta Global Customer Care

All Answers

Stefan PescaruStefan Pescaru (Okta, Inc.)
Hello Arnold, 

You can view the last login of your users within a specific application, by following the path Okta Admin Dashboard > Reports > Reports > Application Usage.
There, please select the filters (application, users,timeframe) accordingly, and run the report. The last column in the result table will contain the timestamp of your users' last login within the app. This report can also be exported as a .CSV.

Thank You,

Stefan Pescaru
Technical Support Engineer
Okta Global Customer Care
This was selected as the best answer
Dylann FezeuDylann Fezeu (Customer First Programs)
Hello Arnold,

Thanks for posting your inquiry in Okta Community Portal.

If you receive a great answer to your question(s), please help readers find it by marking it the best answer. Hover over the answer and click "Best Answer." 

Thank you,

Dylann Fezeu
Okta Help Center Team