Check for single KB installs

Checking for presence of one KB across all devices.

Written by Ines

Last published at: November 9th, 2022

Query Description

Checking for presence of one KB across all devices.

Query Example

Query

select distinct de.DeviceName, wu.KB, wu.Name as 'Description', wu.DateApplied from Devices de

inner join WindowsUpdates wu on de.DeviceId=wu.DeviceId

where wu.KB = 'KB2267602'