Sponsored by Hudson Rock – Use Hudson Rock's free cybercrime intelligence tools to learn how Infostealer infections are leading to ransomware attacks
DeviceNetworkEventslet smb = DeviceNetworkEvents
| where Timestamp > ago(1d)
| where RemotePort == 445
| project DeviceName, RemoteIP, SmbTime = Timestamp;
let webWrite = DeviceFileEvents
| where Timestamp > ago(1d)
| where FolderPath has_any ("wwwroot","htdocs","public_html")
| where ActionType in ("FileCreated","FileModified")
| project DeviceName, WebFile = FileName, WriteTime = Timestamp;
smb
| join kind=inner webWrite on DeviceName
| where WriteTime - SmbTime between (0min .. 2h)
Hunting queries are starting points for threat hunting & detection engineering — validate table/column names against your own workspace schema and tune thresholds before turning any of these into a production alert rule.