Command and Control (TA0011)
Sub-technique: T1071.001 - Web Protocols
DeviceNetworkEvents
| where RemotePort == 80 or RemotePort == 443
| summarize count() by RemoteIP, LocalIP
| where count() > 50
//Extended Search
DeviceNetworkEvents
| where RemotePort == 80 or RemotePort == 443
| summarize ConnectionCount = count() by RemoteIP, DeviceName
| where ConnectionCount > 50
| join kind=leftouter (
DeviceFileEvents
| where FileName endswith ".zip" or FileName endswith ".rar"
| summarize ArchiveFileCount = count() by DeviceName
) on DeviceName
| join kind=leftouter (
DeviceProcessEvents
| where ProcessCommandLine has_any ("curl", "wget", "POST")
| summarize ProcessCount = count() by DeviceName
) on DeviceName
| project RemoteIP, DeviceName, ConnectionCount, ArchiveFileCount, ProcessCount
| order by ConnectionCount descLast updated