It does not seem possible today to use a built-in report from the Okta admin console capable of getting ALL users and ALL user attributes regardless of status and have it scheduled to be sent as an email. We have an internal audit team that monthly asks us to generate these reports. I'm trying to find a way in Workflows to automate this and have trouble doing this as its not very intuitive to build such a workflow.

The objectives are basically:

1. List all users regardless of status, this could include every account that exists in Okta, including deprovisioned accounts.
2. For each user capture all possible user attributes and their values
3. Write the results to a table, where each user would be its own row in a table, and the columns would represent each attribute and contain that attributes data in the cell for that row.
4. Email the report to a specific recipient in CSV format, exporting the full table to CSV and emailing through O365.

So far I've tried read user, list user, filter and search, but while I can get it to list users, having it capture all user attributes is not something I can find a way to do.

Important note: I would prefer not to have to go lookup all potential user properties and manually type them in. It would be great if I could find a way to query for the users and just take the returned list of attributes and use that for processing for the entire streamed dataset output. Then take action on that in the flow to capture each user and their attributes for saving to the table.

Any tips on how I can accomplish this? I keep getting stuck. Its quite frustrating that I can't get a full user report out of the native Okta admin reports center. The rockstar browser extension allows me to get what I need in two separate reports, but its a lot of manual work to go generate these reports and then combine them into a single Excel file for our audit team. I'm trying to eliminate this manual work.