Sponsored by Hudson Rock – Use Hudson Rock's free cybercrime intelligence tools to learn how Infostealer infections are leading to ransomware attacks
DeviceProcessEventslet scan = DeviceProcessEvents
| where Timestamp > ago(1d)
| where FileName has "advanced_ip_scanner"
| project DeviceName, ScanTime = Timestamp;
let discovery = DeviceProcessEvents
| where Timestamp > ago(1d)
| where FileName in~ ("cmd.exe","powershell.exe") and ProcessCommandLine has_any ("dir /s","Get-ChildItem -Recurse")
| project DeviceName, DiscoTime = Timestamp;
scan
| join kind=inner discovery on DeviceName
| where DiscoTime - ScanTime 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.