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): https://social.technet.microsoft.com/wiki/contents/articles/33317.system-center-configuration-manager-sccm-device-collection-query-by-kb-number.aspx

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

0 Comments

Leave a Reply

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