.png?sv=2022-11-02&spr=https&st=2024-12-21T16%3A08%3A43Z&se=2024-12-21T16%3A18%3A43Z&sr=c&sp=r&sig=PQNpmvMhmJtRK%2FTEHO%2BhDmvKBH8Jj0LrL6kW%2BhgQWGw%3D){kind=logo}
Export Authorization Data
- 15 Sep 2023
-
DarkLight
-
PDF
Export Authorization Data
- Updated on 15 Sep 2023
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
In the 2023.2 feature release, customers now have the ability to export a list of Users, Groups, and Roles from the Admin Essentials Authorization page into a CSV-formatted file, which can be named and saved to a download folder on your computer (system).
The CSV data, in turn, can be used as a reference list (data report) to help track what role a user belongs to and see the groups to which each user belongs.
Prerequisities
To utilize this new feature you:
- Must have assigned permissions to read/write roles on user and group entities.
- Must have assigned permissions to perform the export.
Authorization Data File
The items in the CSV file and what they represent are reference below.
| Column Header | Description |
|---|---|
| User ID | Identifier of the user account. |
| Provenance | The name of the AAA the user comes from. |
| Username | The unique name of the user account. |
| First name | The user’s first name. |
| The email address associated with the user account. | |
| Last Login | The last date and time of login. |
| Active | A boolean to indicate if the user account is active. Uses the values “true/false”. |
| Groups Names | A list of group names to which the user belongs. Each group name includes its provenance. |
| Roles Names | A list of roles which are assigned to the user. |
How to Export Authorization Data to CSV File
From the IAP home page:
-
Navigate to IAP → Admin Essentials → Authorization.
-
Click the export icon. A confirmation dialog displays.
Figure 1
-
Click the Download button. A copy of a CSV-formatted file is downloaded to your system.
Figure 2
Figure 3
-
Go to the location where the CSV file is saved.
-
Open the CSV file in your spreadsheet application of choice (e.g., Microsoft Excel, Google Sheets, Smartsheet, etc). In our example (Figure 4), Microsoft Excel is used.
Figure 4
Was this article helpful?
