Use the controls in the grid heading row to sort report results or rearrange the columns of data. An arrow in the column heading identifies the sort criteria and order, ascending or descending, being used to display information.
To sort columns
To move columns
To change the order of the columns, click the heading of the column to be moved. Drag and drop the column to a new location within the grid.
To change the columns that display
In the upper right corner, click Column to see a list of columns that can be displayed in the grid. Select the check box for data to be included in the report. Clear the check box for data to be excluded from the report. The additional columns available depend on the type of activity included in the report.
Reports allows the Auditor and Security Policy Administrators to view and export entitlement reports that show which assets and accounts a selected user is authorized to access. Reports may be exported in .csv or .json format.
The toolbar at the top of Reports contains these options.
Once the report is exported, you can convert timestamps to local time, if necessary.
One Identity Safeguard for Privileged Passwords provides these entitlement reports.
To run an entitlement report
The top of the report displays the following information.
Accounts: Number of accounts each user is allowed to access.
NOTE: If an access request policy allows password access to linked accounts, an account may display twice: once based on the policy scope and a second time because it is a linked account. In the bottom grid, see the column From Linked Account. For more information, see Access Config tab.
Note: For entitlements by assets, you can continue to drill down into the details of an item. For example, you can view both the Total Accounts tab and the People tab to see more details about the users that can request the accounts on an asset. Select an item from the results to drill down further into the details about the users and the accounts.
To export the report
To export, select Export and then select Export as CSV or Export as JSON. Save the file to the location desired. Different information may be returned based on whether you select CSV or JSON. For example, JSON includes details of accounts discovered and CSV includes only the count of accounts.
To run the report
Click the Run button to generate the report.
.csv opened in Excel
Identify how many hours different your local time is from the UTC or GMT exported by googling "UTC to my time". The value will be within the -12 to 12 range.
In the column to the right of the time stamp, enter one of the following formulas. These examples assume the exported time is in cell J1 and the exported time is -7 hours after the current local time.
Below, the exported time stamp is 17:55:59 GMT (5:55:59 pm).
The formula converts the time to the local time stamp of 10:55:59 pm.
You can find code to convert JSON UTC time to local time. One
possible source follows: