↳ GitHub sourceAnalytics ruleLow

UniFi Site Manager: Pending firmware updates outstanding for 7d+

Description

Identifies sites with pending firmware updates outstanding continuously for the last 7 days, indicating patch debt that should be scheduled.

Rule type: Scheduled
Version: 1.0.1
Declared status: Available
Query frequency: 1d
Query period: 7d
Trigger: gt 0

Declared MITRE coverage

Reconnaissance T1595

Declared sources

Metadata from the source file. No dependencies inferred from KQL.

Connectors

UniFiSiteManagerConnectorDefinition

Data types

Unifi_SiteManager_Sites_CL

KQL query

Original query, unchanged.

Unifi_SiteManager_Sites_CL
      | where TimeGenerated > ago(7d)
| extend pendingUpdates = PendingUpdateDevices
      | summarize MinPending = min(pendingUpdates), MaxPending = max(pendingUpdates), arg_max(TimeGenerated, pendingUpdates) by SiteId, SiteName
      | where MinPending > 0
      | extend Activity = strcat('Pending updates sustained - current ', pendingUpdates, ' device(s)')
      | project TimeGenerated, SiteId, SiteName, Activity, PendingDevices = pendingUpdates

Declared entities

Host

Source provenance

GitHub

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

File: Solutions/UniFi Site Manager (CCF)/Analytic Rules/UniFiCloudPendingfirmwareupdatesoutstandingfor7d.yaml ↗
Commit: 9800e51 ↗
Source identifier: d943d401-861e-7186-d42c-c505fbf7c619

Additional source files 2

Solutions/UniFi Site Manager (CCF)/Analytic Rules/UniFiCloudPendingfirmwareupdatesoutstandingfor7d.yamlsource ↗Solutions/UniFi Site Manager (CCF)/Data/Solution_UnifiSiteManager.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.