Share via

System Center Configuration Manager (SCCM): Device Collection Query by KB Number

  • Article

https://msdnshared.blob.core.windows.net/media/2016/05/0640_NinjaAwardTinyGold.pngGold Award Winner

Attached is a WMI query that is very helpful to determine machines that have a certain KB article installed on them.

It's useful when you need to apply additional modifications or install certain programs to these machines. 

select  SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on  SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where  SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%KB3114409%"