← Back to SOC feed Coverage →

Malware Detections by Sender Country

kql MEDIUM Azure-Sentinel
T1566
EmailEvents
huntingmicrosoftofficial
This rule was pulled from an open-source repository and enriched with AI. Validate in a test environment before deploying to production.
View original rule at Azure-Sentinel →
Retrieved: 2026-09-03T11:00:00Z · Confidence: medium

Hunt Hypothesis

This hypothesis targets adversaries leveraging phishing campaigns (T1566) that originate from geographically inconsistent or high-risk sender countries to bypass initial email security controls. Proactively hunting for these patterns in Azure Sentinel allows the SOC to identify potential supply chain compromises or targeted intrusion attempts that may have evaded real-time detection, ensuring rapid containment of malware-laden emails before they reach user inboxes.

KQL Query

EmailEvents
| where Timestamp > ago(30d)
| where OrgLevelPolicy != "Phishing simulation" and OrgLevelPolicy != "SecOps Mailbox"
| extend Key = strcat(NetworkMessageId, "-", RecipientEmailAddress)
| summarize arg_max(Timestamp, *) by Key
| where ThreatTypes has "Malware" and isnotempty(SenderIPv4)
| extend GeoInfo = geo_info_from_ip_address(SenderIPv4)
| extend Country = tostring(GeoInfo.country)
| summarize count() by Country
| project Country, ['Malware Emails'] = count_
| sort by ['Malware Emails'] desc

Analytic Rule Definition

id: 2e1c439b-9bbf-4d1a-a8c1-2a9f9149f3e5
name: Malware Detections by Sender Country
description: |
  This query summarises inbound email malware detections by the sender IP address country, derived from the sender IPv4 address.
description-detailed: |
  This query summarises inbound email malware detections in Microsoft Defender for Office 365 by the sender IP address country, derived from the sender IPv4 address using geo_info_from_ip_address.
  Messages are de-duplicated to the latest record per NetworkMessageId and recipient, and deliveries to the SecOps mailbox and by the phishing simulation system are excluded.
requiredDataConnectors:
- connectorId: MicrosoftThreatProtection
  dataTypes:
  - EmailEvents
tactics:
  - InitialAccess
relevantTechniques:
  - T1566
query: |
  EmailEvents
  | where Timestamp > ago(30d)
  | where OrgLevelPolicy != "Phishing simulation" and OrgLevelPolicy != "SecOps Mailbox"
  | extend Key = strcat(NetworkMessageId, "-", RecipientEmailAddress)
  | summarize arg_max(Timestamp, *) by Key
  | where ThreatTypes has "Malware" and isnotempty(SenderIPv4)
  | extend GeoInfo = geo_info_from_ip_address(SenderIPv4)
  | extend Country = tostring(GeoInfo.country)
  | summarize count() by Country
  | project Country, ['Malware Emails'] = count_
  | sort by ['Malware Emails'] desc
version: 1.0.0

Required Data Sources

Sentinel TableNotes
EmailEventsEnsure this data connector is enabled

MITRE ATT&CK Context

References

False Positive Guidance

Original source: https://github.com/Azure/Azure-Sentinel/blob/main/Hunting Queries/Microsoft 365 Defender/Email and Collaboration Queries/Malware/Malware Detections by Sender Country.yaml