One Identity Safeguard for Privileged Passwords 2.9 - Administration Guide

Sorting report results

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

1. Click the column heading to be used for the sort criteria.
2. The sort order is in ascending order. To change it to descending order, click the heading a second time.
3. To specify a secondary sort order, press the SHIFT key and then click the heading of the column to be used for the secondary sort order.

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

 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.

Entitlement reports

One Identity Safeguard for Privileged Passwords provides these entitlement reports.

• User: Lists information about the accounts a selected user is authorized to request.
• Asset: Lists information about the accounts associated with a selected asset and the users who have authorization to request those accounts.
• Account: Lists detailed information about the users who have authorization to request a selected account including: Entitlement, Policy, Access Type, Password Included, Password Change, Time Restrictions, Expiration Date, Group, From Linked Account, and Last Accessed.

Running an entitlement report

To run an entitlement report

1. From the Safeguard for Privileged Passwords desktop Home page, select  Reports.
2. In the first drop-down, choose a type of report: User, Asset or Account.
3. In the second drop-down, you can select All or you can select Browse to select one or more objects for the report.

4. The top of the report displays the following information.

   User:

   • Name: The name of the user.
   • Username: The user name used for authentication.
   • Domain name: The name of the domain of the user.

   • 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.

   Asset:

   • Name: The name of the asset.
   • Accounts: Number of accounts on this asset that can be accessed.
   • Requesters: Number of users allowed to request access to the asset's accounts.
   • Partition: The name of the partition to which the asset belongs.
   • Users: The name of the requesters allowed to request access.

   Account:

   • Name: Name of the account.
   • Asset: Name of the asset associated with the account.
   • Domain Name: If applicable, the domain of the account.
   • Requesters: Number of requesters allowed to access an account.
5. Select an item from the top pane to view additional detail in the lower pane.
   

   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.

6. To filter the results, use the filter control in the column heading. For more information, see Filtering report results.

To export the report

1. 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.

2. Once the report is exported, you can convert timestamps to local time, if necessary. For more information, see Converting timestamps.

To run the report

Click the Run button to generate the report.

Converting timestamps

When you export .csv or .json files, the time stamp will be in UTC/GMT time. You can convert the time to your local time.

.csv opened in Excel

1. 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.

2. 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.

   • =J1-TIME(7,0,0)
   • =J1+(-7 / 24)

   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.

   

.json

You can find code to convert JSON UTC time to local time. One

possible source follows:

https://stackoverflow.com/questions/42376914/json-utc-time-to-local-time