Microsoft Sentinel medium experimental kql

DDoS Attack IP Addresses - PPS Threshold

Identifies IP addresses that generates maximal traffic rate over 10k PPS during DDoS attack mitigation

View Source

Detection Logic

AzureDiagnostics
| where ResourceType == 'PUBLICIPADDRESSES' and Category == "DDoSMitigationFlowLogs"
//sample rate of mitigation device 1:1000 so the PPS of the source is estimated to be x1000.
| extend destPublicIpAddress_s = coalesce(tostring(column_ifexists("destPublicIpAddress_s", "")), tostring(column_ifexists("AdditionalFields", dynamic({}))["destPublicIpAddress"]), tostring(todynamic(column_ifexists("ResultDescription", ""))["destPublicIpAddress"]))
| extend sourcePublicIpAddress_s = coalesce(tostring(column_ifexists("sourcePublicIpAddress_s", "")), tostring(column_ifexists("AdditionalFields", dynamic({}))["sourcePublicIpAddress"]), tostring(todynamic(column_ifexists("ResultDescription", ""))["sourcePublicIpAddress"]))
| summarize PPS = 1000 * count() by destPublicIpAddress_s, sec = bin(TimeGenerated, 1s), sourcePublicIpAddress_s
| summarize maxPPS = max(PPS) by destPublicIpAddress_s, sourcePublicIpAddress_s
| order by destPublicIpAddress_s, maxPPS desc
| where maxPPS > 10000

Field Validations

Loading…

Comments (0)

Loading comments...