<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
System Status
Announcements
Announcements
Search
Search
Select Language
Knowledge Base
Knowledge Articles
Support Videos ↗
Documentation
Product Documentation ↗
Developer Documentation ↗
Product Release Notes ↗
Community
Events & Webinars
Okta Ideas ↗
Resources
Product Hub
Customer Success Hub
Product Release Update
Learning
Okta Learning ↗
Get Support
Open a Case
HomeCommunityForum
0D50Z00008G7UzASAVOkta Classic EngineSingle Sign-OnAnswered2024-04-30T09:18:25.000Z2018-04-05T20:09:01.000Z2018-08-12T04:15:27.000Z

0aznj (0aznj) asked a question.

Edited by varun.kavoori1.5210444522562532E12 September 5, 2018 at 1:19 AM
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
  • 2 answers
  • 763 views

  • stefan.pescaru1.4793088119572407E12 (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
    Expand Post
    Selected as Best

  • stefan.pescaru1.4793088119572407E12 (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
    Expand Post
    Selected as Best

  • j5v7c (j5v7c)

    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
    Expand Post
This question is closed.
Loading
SQL request