This article presents how to create an Application Usage report that contains data about who has signed in to an app integration during a specified time period. This report can be run for all app integrations in the Okta environment or for specific app integrations. This report can be used to determine which apps are used the least.

• Reports
• App integrations

To generate the Application Usage report, please follow the steps:

1. In the Admin Console, go to Reports > Reports.

2. Select Application Usage. The Application Usage page opens.

3. Select the desired information for the From, To, Application, User, and Group report parameters.
4. Click Request report. Okta will send this report via email, and it can be downloaded from there. 

NOTE: If the Application Usage report is generated without adding a specific Application, User, or Group (as in the screenshot from step 4), the report will contain all the users that accessed all the applications from the Okta tenant. In order to refine the report after it is generated, the two options below can be used:

1. Using the Pivot Table function from Excel:
   1. Open the CSV file containing the app usage report.
   2. Go to the Insert tab, click on Pivot Table (it should be the first thing in the toolbar), and on From Table/Range.
   3. Select the entire report, including the table headers.
   4. In the Choose where you want the Pivot Table report to be placed setting, choose New Worksheet and click OK.
   5. In the pivot table's settings, check the Login, Instance Name, and Login Date_ISO8601 fields.
   6. Move the Instance Name field to Columns (Optional: It can be kept as a row if needed, but then it is recommended to move it above the Login field) and Login Date_ISO8601 to Values. The value will be automatically converted to a count.
2. Opening the App Usage report in Google Sheets:
   1. Export App usage report without app username.
   2. Open the CSV in Google Sheets.
   3. Sort by Login date and remove all the events outside of the preferred time.
   4. Copy the Login and Instance name columns into other columns (preferably H and I columns).
   5. Select the two columns that were copied over.
   6. Go to the Toolbox menu at the top > Data > Data cleanup > Remove Duplicates.
   7. Select the second row from column K (other columns can be selected based on preference, as long as they are empty).
   8. Input the following function: =COUNTIFS($B$2:$B${rows}, H2, $C$2:$C${rows}, I2).
      • Replace {rows} with the number of rows in the Excel file. For example, the B column contains the first Login column, and C contains the first Instance name column.
   9. Apply the function, and drag the box until it covers all rows from the H and I columns.
       

NOTE:

• On the K column, the number of accesses by the user from the H column will be displayed for the app on the I column. 
• This will work only if the report is opened in Google Sheets. 

Related References

• Application Usage report