google_workspace_multiple_files_sent_as_email_attachment_from_google_drive
Description
Identifies when a user sends multiple files from Google Drive as an email attachment to a free email domain, which may indicate data exfiltration.
Query · yara_l
events:
$email.metadata.vendor_name = "Google Workspace"
$email.metadata.product_name = "drive"
$email.metadata.event_type = "EMAIL_TRANSACTION"
$email.metadata.product_event_type = "email_as_attachment"
$email.target.user.email_addresses = /.*@gmail\.com|.*@aol\.com|.*@ymail\.com|.*@ymail\.com|.*@hotmail\.com|.*@outlook\.com|.*@icloud\.com/
$email.principal.user.userid = $user_id
match:
$user_id over 1h
outcome:
$risk_score = max(75)
$mitre_attack_tactic = "Exfiltration"
$mitre_attack_technique = "Exfiltration Over Web Service"
$mitre_attack_technique_id = "T1567"
$event_count = count_distinct($email.metadata.id)
$product_event_type = array_distinct($email.metadata.product_event_type)
$userid = array_distinct($email.principal.user.userid)
$doc_type = array_distinct($email.src.resource.attribute.labels["doc_type"])
$owner = array_distinct($email.target.resource.attribute.labels["owner"])
$target_emails = array_distinct($email.target.user.email_addresses)
$doc_name = array_distinct($email.target.resource.name)
$doc_id = array_distinct($email.target.resource.product_object_id)
$count_docs = count_distinct($email.target.resource.product_object_id)
condition:
// Customize the value of $count_docs to set the alerting threshold for your environment
$email and $count_docs > 10