↳ GitHub sourceAnalytics ruleHigh
Critical Finding Overdue on Internet-Facing App
Description
Detects Critical and High severity findings older than 7 days that remain
open on internet-facing applications. Uses the InternetFacingApps watchlist
to scope results to externally exposed assets requiring urgent remediation.
- Rule type
- Scheduled
- Version
- 1.0.0
- Declared status
- Available
- Query frequency
- 1d
- Query period
- 1455m
- Trigger
- gt 0
Declared MITRE coverage
Declared sources
Metadata from the source file. No dependencies inferred from KQL.
Connectors
Data types
KQL query
Original query, unchanged.
let maxAgeDays = 7;
let InternetFacingList = _GetWatchlist("InternetFacingApps")
| project WL_ApplicationId = column_ifexists("ApplicationId", ""),
WL_AppName = column_ifexists("AppName", ""),
WL_Owner = column_ifexists("Owner", "");
StratoSecure_Findings_CL
| where FixStatus =~ "open"
| where Severity in ("Critical", "High")
| extend AgeInDays = datetime_diff("day", now(), TimeGenerated)
| where AgeInDays > maxAgeDays
| join kind=inner InternetFacingList on $left.ApplicationId == $right.WL_ApplicationId
| summarize TotalOverdueFindings = count(), OldestAge = max(AgeInDays),
RuleIds = make_set(RuleId, 20), EndTime = max(TimeGenerated)
by ApplicationId, WL_AppName, WL_Owner, StraTenantId
| project TimeGenerated = EndTime, ApplicationId, AppName = WL_AppName, Owner = WL_Owner,
StraTenantId, TotalOverdueFindings, OldestAge, RuleIds
Declared entities
Related content
Links established from declared identifiers and solution manifests.
Source provenance
GitHubDisplayed values come from files in Azure/Azure-Sentinel. They describe the published template, not your workspace configuration.
- Commit
9800e51↗- Source identifier
88c4b680-db1c-46b9-8ca4-4165c3abf63f
GSTEP / CATALOG TRACKING
Added to catalog : 16 Sept 2026 · 05:49 UTC
Last change observed : 16 Sept 2026 · 05:49 UTC