↳ 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

CloudApplication

Related content

Links established from declared identifiers and solution manifests.

Source provenance

GitHub

Displayed values come from files in Azure/Azure-Sentinel. They describe the published template, not your workspace configuration.

Source identifier
88c4b680-db1c-46b9-8ca4-4165c3abf63f
Additional source files 2Solutions/StratoSecure/Analytic Rules/S6_CriticalFinding_Overdue.yamlsource ↗Solutions/StratoSecure/Data/Solution_StratoSecure.jsonsolution-membership ↗
GSTEP / CATALOG TRACKING

Added to catalog : 16 Sept 2026 · 05:49 UTC
Last change observed : 16 Sept 2026 · 05:49 UTC

GSTEP sync dates, separate from the source content’s publication dates.