How can I get a report with the list of all the user and the applications assigned to them? Skip to main content
https://support.okta.com/help/answers?id=9060z000000jjodqas&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:
malli ithamalli itha 

How can I get a report with the list of all the user and the applications assigned to them?

Ruchir ParikhRuchir Parikh (Okta, Inc.)
Hello Malli, 

To generate a report with the list of all the users and their applications assigned to them, it will need to be done using the Okta API. You can use the App collection to call the "List Apps Assigned to User" endpoint ({{url}}/api/v1/apps?filter=user.id+eq+"{{userId}}"&expand=user/{{userId}}). I am providing links below to assist you with creating a script that will generate this report for you. Okta does have an early access feature (OKTA_USER_LISTS_FOR_AUDITING) that will allow you to run this report in the web GUI for a single user at a time. 

Getting Started With the Okta APIs - https://developer.okta.com/docs/api/getting_started/api_test_client
List Apps Assigned to User - https://developer.okta.com/docs/api/resources/apps#list-applications-assigned-to-user
Pagination -  https://developer.okta.com/docs/api/getting_started/design_principles#pagination
Sample Python Scripts - https://github.com/SohaibAjmal/Okta-UD-Scripts

Thank You,

Ruchir Parikh
Technical Support Engineer
Okta Global Customer Care