SQL Script - Check for single KB installs
Checking for presence of one KB across all devices.
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'