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.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%" |
0 Comments