CraigB.72839 (Bowdoin College) asked a question.
Can you export the tasks lists as a csv for example a list of app assignment errors?
I want to easily extract the list of email address in the app assignment errors task.
oxptp (oxptp)There is no 'easy' way to export those to a CSV. I personally use a python script that I've put together to export a CSV list of any failures for a particular application. I make a call to /api/v1/apps/{{appId}}/users to get all users assigned to the application, then filter that list to find anyone with syncState 'ERROR'. Hopefully this helps point you in the right direction. https://github.com/cloudkevin/Okta-ExportAssignmentFailures
Expand Post- CraigB.72839 (Bowdoin College)Kevin,
Thanks! I got your script to work in my preview environment but when I run it in prod it appears to only return the first 50 results. What am I missing?
Craig Bowden
Associate Network and Security Engineer
Information Technology
Bowdoin College
W-207-725-3036
C-207-653-8475Expand Post - CraigB.72839 (Bowdoin College)Kevin,
I figured out my limit problem. Thanks.
Craig Bowden
Associate Network and Security Engineer
Information Technology
Bowdoin College
W-207-725-3036
C-207-653-8475Expand Post
- gabriel.sroka1.4374539321839353E12 (Okta, Inc.)
Kevin,
Thanks for sharing your Python code. I added syncState to rockstar (which is an in-browser tool to export users, groups, etc. from Okta to a CSV file):
https://gabrielsroka.github.io/rockstar
It will also paginate, and watch rate limits.
Gabriel
Expand Post - oxptp (oxptp)
Thank you! Definitely an improvement over what I provided. I use and recommend your tool to most of my clients, it's a huge time saver for all of us.
- gabriel.sroka1.4374539321839353E12 (Okta, Inc.)
Kevin,
Thanks for using rockstar and recommending it to your clients. If you have any recommendations on how to make it better, please reply here or open an issue on my GitHub repo.
Gabriel
Expand Post
This question is closed.
There is no 'easy' way to export those to a CSV. I personally use a python script that I've put together to export a CSV list of any failures for a particular application. I make a call to /api/v1/apps/{{appId}}/users to get all users assigned to the application, then filter that list to find anyone with syncState 'ERROR'. Hopefully this helps point you in the right direction. https://github.com/cloudkevin/Okta-ExportAssignmentFailures