Microsoft Sentinel high experimental kql

BOLA Finding with API Traffic Anomaly

Detects applications with open BOLA/IDOR findings (OWASP API1, API3, API5) that also show anomalous 4xx error traffic in Azure API Management. Correlates StratoSecure BOLA findings with APIM gateway error spikes.

View Source

Detection Logic

let lookback = 1h;
let enumThreshold = 100;
let BolaFindings = StratoSecure_Findings_CL
| where TimeGenerated >= ago(lookback)
| where FixStatus =~ "open"
| where OwaspCategory in ("API1", "API3", "API5")
| where Severity in ("Critical", "High")
| summarize FindingCount = count(), RuleIds = make_set(RuleId)
        by ApplicationId, StraTenantId;
let TrafficAnomalies = ApiManagementGatewayLogs
| where TimeGenerated >= ago(lookback)
| where ResponseCode in (403, 401, 404)
| summarize ErrorCount = count(), DistinctCallers = dcount(CallerIpAddress),
        Paths = make_set(Url, 30), LastSeen = max(TimeGenerated)
        by ApiId, OperationId
| where ErrorCount >= enumThreshold;
BolaFindings
| join kind=inner TrafficAnomalies on $left.ApplicationId == $right.ApiId
| project TimeGenerated = LastSeen, ApplicationId, StraTenantId,
        FindingCount, RuleIds, ErrorCount, DistinctCallers, Paths

Field Validations

Loading…

Comments (0)

Loading comments...