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.

Query · kql

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
Raw source Malware Detections by Sender Country · KQL
Esc
Published by Azure/Azure-Sentinel ↗, licensed under MIT ↗. Reproduced here unmodified.
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

Detection rules belong to the projects that publish them and remain under their own licenses. This site indexes and links to them; it claims no rights in them.