Reporting: Recommendations for extracting data to be able to report beyond log retention Skip to main content
https://support.okta.com/help/answers?id=9060z00000078knqay&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:
Fred CosegliaFred Coseglia 

Reporting: Recommendations for extracting data to be able to report beyond log retention

This is a general reporting question.  On line transaction history is 6 months.  Is there a set of practices / recommendations from Okta so that a customer has access to the transaction history and can report on it beyond the six month (of on line history).

For example, the Application Usage Report...a very useful report, however, if we wanted to see access trends over a 12 month period of time, the data would not be online.

Presuming the data needs to be off loaded, is it best to use an existing report and call it via an API to pull the data off or is there some other recommended approach?
Aleks BulajicAleks Bulajic (Okta, Inc.)

Hi Fred,

Thanks for reaching out to the Support Community! At this time, Okta does not provide a method for extracting the same results as provided by the built-in reports in the Admin UI via the API. However, you would be able to integrate the Okta API with a SIEM solution such as Splunk to routinely extract data from the Okta API on a routine basis which will give you access to those logs for as long as you decide to keep them.

In addition, with the use of our API documentation (https://developer.okta.com/code/rest/), one could obtain similar results as what is provided in the built-in reports.
For example, using the attached call will bring up the last 100 app authentication events for a specific application:
{{url}}/api/v1/events?limit=100&filter=action.objectType eq "app.auth.sso" and target.id eq "{{appId}}"

Exporting Okta Log Data: https://support.okta.com/help/Documentation/Knowledge_Article/Exporting-Okta-Log-Data

Thank you,

Aleks Bulajic
Technical Support Engineer
Okta Global Customer Care