google_workspace_alerts_aggregated_by_severity
Description
Generates alerts based on Google Workspace alerts center and aggregates them based on severity.
Query · yara_l
events:
$ws.metadata.vendor_name = "Google Workspace"
$ws.metadata.product_name = "Google Workspace Alerts"
$ws.security_result.severity = $severity
match:
$severity over 1h
outcome:
$risk_score = max(30 +
if($ws.security_result.severity = "LOW", 10)+
if($ws.security_result.severity = "MEDIUM", 30)+
if($ws.security_result.severity = "HIGH", 50)
)
$event_count = count_distinct($ws.metadata.id)
$event_type = array_distinct($ws.metadata.event_type)
$product_event_type = array_distinct($ws.metadata.product_event_type)
$security_category_details = array_distinct($ws.security_result.category_details)
$security_category = array_distinct($ws.security_result.category)
$security_investigation_tool_link = array_distinct($ws.security_result.detection_fields["security_investigation_tool_link"])
$security_summary = array_distinct($ws.security_result.summary)
$alert_severity = array_distinct($ws.security_result.severity)
condition:
$ws