Track Sentinel incident volume and ownership
Summarize Sentinel incidents by severity, status, owner, and day for SOC handoff and workbook reporting.
beginnersentinel-operationsoperational-excellence
- Run surface
- Sentinel Logs, Azure Monitor Logs
- Required tables
- SecurityIncident
kql
SecurityIncident
| where TimeGenerated > ago({lookback})
| summarize Incidents=dcount(IncidentNumber), Latest=max(TimeGenerated) by bin(TimeGenerated, 1d), Severity, Status, Owner
| order by TimeGenerated desc, Incidents descSource: KQLMSPress/definitive-guide-kql Chapter 2: Data Aggregation/Query Samples. Adapted from aggregation and operational dashboard patterns for Sentinel incident operations.