Monday, April 30, 2012

How to create collection in sccm 2007 with only windows 2008 R2

Step1: Go to Configuration Manager Console
Step2: Right click on Collection and New Collection
Step3: Give the name of collection
Step4: Go to Query Rule Properties
Step5: Give the name of New Query
Step6: Edit Query Statement
Step7: Show Query Language
Step8: Put Query as below
<<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 where OperatingSystemNameandVersion like '%Server 6.1%' >>


Enjoy