Supporting Windows Question

how to create query rule in sccm 2007 for create windows hotfix(%KB4012212%) collection

07/12/2017 819 views
Please help me to create collection in sccm2007 based on %KB4012212% update collection. i tried to create one rule (below) but its not worked. my all client computers are windows 7.
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 not like "%KB4012212%" and SMS_R_System.OperatingSystemNameandVersion like "%Workstation 6.1%" and SMS_R_System.ResourceId in (select ResourceID from  SMS_R_System where ResourceID in (select ResourceID from SMS_CM_RES_COLL_SMS00004))
0 Comments   [ + ] Show comments


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ