System Center Configuration Manager (SCCM): Device Collection Query by KB Number
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%" |
0 Comments