Microsoft Sentinel medium experimental kql

CiscoISE - Device PostureStatus changed to non-compliant

'Detects when device changes PostureStatus from "Compliant".'

View Source

Detection Logic

let lbtime_48h = 48h;
let lbtime_24h = 24h;
let lbtime_now = now();
let compliantIPs = CiscoISEEvent
| where TimeGenerated between (ago(lbtime_48h) .. ago(lbtime_24h))
| where PostureStatus == 'Compliant'
| summarize makelist(DstIpAddr)
;
CiscoISEEvent
| where TimeGenerated between (ago(lbtime_24h) .. lbtime_now)
| where PostureStatus != 'Compliant'
| where DstIpAddr in (compliantIPs)
| project DstIpAddr
| extend IPCustomEntity = DstIpAddr

Field Validations

Loading…

Comments (0)

Loading comments...