Hi all,

I know how to bulk import users into Okta via CSV file. My question is, is there a way to then export those newly created users (it's the Okta assigned Sub that I need) so they can then be bulk imported into a SQL database elsewhere?

I am aware there are reports within the Admin console of Okta, but these do not contain the information I need, and are also for "Active" users. My newly imported users would be of status "Pending User Action", awaiting the users to log in for the first time.

Any help you may be able to shed on this matter would be hugely appreciated.

Regards,

John