SQL Script - Check for single KB installs

Checking for presence of one KB across all devices.

Written by Ines

Last published at: April 14th, 2023

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'