Creating an Application Usage Report using API

Loading

Skip to Navigation Skip to Main Content

Search

Search

Select Language

0D51Y0000ARGxmGSQTOkta Classic EngineAdministrationAnswered2026-06-17T16:06:44.000Z2021-02-05T01:32:01.000Z2026-06-17T16:06:44.000Z

bsog9 (bsog9) asked a question.

February 5, 2021 at 1:32 AM

Creating an Application Usage Report using API

I know that this report can be pulled manually as an admin, but I would like to create a report where I am able to see when users last logged into a certain application using the API for automation. From the API documentation, I've tried using List Users Assigned to App (https://developer.okta.com/docs/reference/api/apps/*list-users-assigned-to-application), but the information returned doesn't include Last Login info. How can I extract Last Login info using the API?

Top Rated Answers

aysr3 (aysr3)
5 years ago
If you go to https://developer.okta.com/docs/reference/api/apps and do a page find for "List users assigned", it will take you to the code. There are a bunch of other API examples on that page, as well.
Expand Post
Selected as Best

All Answers

bsog9 (bsog9)
5 years ago
Working link: https://developer.okta.com/docs/reference/api/apps/#list-users-assigned-to-application
Expand Post
- 00u1yte8l9izgD2Sj1t1.4921009006268708E12 (Customer)
  5 years ago
  This link is not functional.
  Expand Post
- 00u1yte8l9izgD2Sj1t1.4921009006268708E12 (Customer)
  5 years ago
  This link is not functional.
  Expand Post
User15803830581701390301 (CS – ServiceSource)
5 years ago
Hello Team the link isn't working
Expand Post
aysr3 (aysr3)
5 years ago
If you go to https://developer.okta.com/docs/reference/api/apps and do a page find for "List users assigned", it will take you to the code. There are a bunch of other API examples on that page, as well.
Expand Post
Selected as Best
00ujv8u39sGoJ6pvW351.5571846845572803E12 (Customer)
5 years ago
In case anyone is still wondering about this question, getting the last login can be done via an API query for the latest app login event matching the user ID and target app ID. You'll want to use the following query parameters:

limit=1
sortOrder=descending
filter=event_type eq "user.authentication.sso" and target.id eq "<appID>" and actor.id eq "<userID>"

Don't ask me why this particular filter parameter is the only place in all of Okta where the Event Type property is named event_type instead of eventtype. Just be aware that it won't work without the underscore in there, so if you're getting zero results that may be why.

The "published" property in the response will give you the UTC time of the user's last login to the app.
Expand Post

This question is closed.

Recommended content

Forum

Create Application Usage Report from API

Forum

Generate/Download Application Usage Report from API

Forum

Okta Authenticator in Application Usage Report

Forum

Automating Usage Reports

Loading

Creating an Application Usage Report using API