Microsoft Sentinel low experimental kql
UniFi Site Manager: Firmware Update Available
Identifies UniFi devices with firmware updates available. Keeping firmware patched is critical as updates often include security vulnerability fixes.
Detection Logic
Unifi_SiteManager_Devices_CL
| where TimeGenerated > ago(1d)
| summarize arg_max(TimeGenerated, *) by Id
| where isnotempty(UpdateAvailable)
| extend DeviceDetail = strcat(coalesce(Name, "Unnamed"), " (", Model, ") ", Version, " -> ", UpdateAvailable, " @", Ip)
| summarize
DevicesNeedingUpdate = count(),
DeviceList = make_list(DeviceDetail),
Models = make_set(Model),
ProductLines = make_set(ProductLine)
| where DevicesNeedingUpdate >= 1
| extend
TimeGenerated = now(),
AffectedModels = strcat_array(Models, ", "),
AffectedProductLines = strcat_array(ProductLines, ", "),
DeviceListString = strcat_array(DeviceList, "; ")
| extend Activity = strcat(DevicesNeedingUpdate, ' device(s) have firmware updates available: ', AffectedModels)
| project
TimeGenerated,
DevicesNeedingUpdate,
AffectedModels,
AffectedProductLines,
Activity,
DeviceListString Field Validations
Loading…
Comments (0)
Loading comments...