Check for single KB installs

Checking for presence of one KB across all devices.

Written by Ines

Last published at: November 18th, 2020

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'