okta_user_logins_from_multiple_cities
Description
Detects user logins for same user from different cities within 24 hours.
Query · yara_l
events:
$login.metadata.product_name = "Okta"
$login.metadata.vendor_name = "Okta"
$login.metadata.event_type = "USER_LOGIN"
$login.metadata.product_event_type = "user.session.start"
$login.security_result.summary = "User login to Okta"
$login.principal.user.userid = $userid
$login.principal.location.city = $city
match:
$userid over 24h
outcome:
$risk_score = max(
35 +
// If the IP Address is marked as suspicious IP address by Okta ThreatInsight
if($login.security_result.detection_fields["threatSuspected"] = "true", 30) +
// Unauthorized target geographies
if($login.principal.ip_geo_artifact.location.country_or_region = "Cuba", 20) +
if($login.principal.ip_geo_artifact.location.country_or_region = "Iran", 20) +
if($login.principal.ip_geo_artifact.location.country_or_region = "North Korea", 20) +
if($login.principal.ip_geo_artifact.location.country_or_region = "Russia", 20) +
if($login.principal.ip_geo_artifact.location.country_or_region = "Syria", 20)
)
$mitre_attack_tactic = "Defense Evasion, Persistence, Privilege Escalation, Initial Access"
$mitre_attack_technique = "Valid Accounts"
$target_user_agent = array_distinct($login.network.http.user_agent)
$principal_ip = array_distinct($login.principal.ip)
$principal_ip_country = array_distinct($login.principal.ip_geo_artifact.location.country_or_region)
$principal_ip_state = array_distinct($login.principal.ip_geo_artifact.location.state)
$principal_ip_city = array_distinct($login.principal.location.city)
$dc_principal_ip_city = count_distinct($login.principal.location.city)
$security_result_summary = array_distinct($login.security_result.summary)
$principal_user_managers_email_addresses = array_distinct($login.principal.user.managers.email_addresses)
$principal_user_userid = array_distinct($login.principal.user.userid)
$target_user_email_addresses = array_distinct($login.target.user.email_addresses)
$target_user_userid = array_distinct($login.target.user.userid)
condition:
$login and $dc_principal_ip_city > 1