How can I export list of all users in Okta? Skip to main content
https://support.okta.com/help/answers?id=906f0000000blrsiay&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:
Tae KimTae Kim 

How can I export list of all users in Okta?

api-workday api-workdayapi-workday api-workday

Hi Tae,

There isn't currently a way to do this through the GUI.

Leveraging the okta API you can do it pretty easily. The API is documented here (http://developer.okta.com/docs/api/getting_started/design_principles.html" target="_blank).

If you are working on or have access to a windows system and want to leverage some prior work i've built a powershell module that can be used to do it. The powershell module can be found here (https://github.com/mbegan/Okta-PSModule" target="_blank)along with some basic documentation on getting it setup.

The resulting script to download and export basic information about your users would look something like this.

$users = oktaListUsers -oOrg prod
$toexport = New-Object System.Collections.ArrayList

foreach ($u in $users)
{
    $line = @{
              oktaid = $u.id
              login = $u.profile.login
              firstName = $u.profile.firstName
              lastName = $u.profile.lastName
              email = $u.profile.email
             }
    $obj = New-Object psobject -Property $line
    $_c = $toexport.Add($obj)
}

$toexport | Export-Csv -Path c:\temp\exp1.csv -NoTypeInformation

-Matt
Madhu Mahadevan - SEMadhu Mahadevan - SE (Okta, Inc.)
Hi Tae,

Can you try this? Head to your Reports section in your Admin Console.

Download the "Okta Password Health" report.  That might do the trick.

Madhu Mahadevan, Sr. Sales Engineer, Okta

User-added image
Yuvraj Kukar (Admin)Yuvraj Kukar (Admin)
Hi Matt -

Above powershell script works for me but it is limiting to 120 user limit. Can you suggest how to open the pagination limit to retieve all accounts with this query?

Thanks,