logins_from_terminated_employees
Description
Allowed Logins from Terminated Employees
Query · yara_l
events:
$login.metadata.event_type = "USER_LOGIN"
$login.security_result.action = "ALLOW"
$login.target.user.userid = $user
$login.target.user.termination_date.seconds > 0
$login.target.user.termination_date.seconds < $login.metadata.event_timestamp.seconds
match:
$user over 1d
outcome:
$risk_score = 65
$event_count = count_distinct($login.metadata.id)
$employee_last_login = max($login.target.user.termination_date.seconds)
$total_distinct_ips = count_distinct($login.principal.ip)
// added to populate alert graph with additional context
$principal_hostname = array_distinct($login.principal.hostname)
$target_hostname = array_distinct($login.target.hostname)
$principal_user_userid = array_distinct($login.principal.user.userid)
// Commented out target.user.userid because it is already represented in graph as match variable. If match changes, can uncomment to add to results
//$target_user_userid = array_distinct($login.target.user.userid)
$principal_resource_name = array_distinct($login.principal.resource.name)
$target_resource_name = array_distinct($login.target.resource.name)
$target_url = array_distinct($login.target.url)
condition:
$login