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

Published by Jose on

This is the post that got me the SCCM Technical Guru Award (Gold):

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.ClientfromSMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMSonSMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceIdwhereSMS_G_System_ADD_REMOVE_PROGRAMS.DisplayNamelike "%KB3114409%"
Categories: Uncategorized


Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *