<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
How to Identify All Successfully Logged In User's Locations
Administration
Okta Classic Engine
Okta Identity Engine
Overview

This article explains how to identify which countries are currently successfully logging into the organization based on username.

Applies To
  • Administration
  • Reports
Solution

Please follow the steps:

  1. Navigate to Reports > System Log.
  2. Set the From and To Date and Time values.
  3. Search for the following: 
    eventType eq "user.session.start" and outcome.result eq "SUCCESS"
  4. Click Download CSV.
  5. Open the CSV file using a spreadsheet software such as Google Sheets or Microsoft Excel.
  6. Filter the dataset to include only the following columns:
    • actor.alternate_id
    • client.geographical_context.country
    • client.geographical_context.city
    • request.ip_chain.geographical_context.geolocation.state
  7. Remove duplicates based on the fields mentioned in the previous step.
  8. A de-duplicated list of all users and their successfully logged-in locations for the specified timeframe will now be available.

Related References

Loading
How to Identify All Successfully Logged In User's Locations