Wednesday, 27 July 2016

Creating Device Collection based on OU in SCCM 2012


Device Collection based on OU
1. Browse to Assets and Compliance, right click on Device Collections and select “Create Device Collection”.
2. Give the collection a meaningful name, and set the limiting collection.
3. Add a Query Rule.

4. Edit Query Statement.

5. Head to the criteria tab, and click on the new star item.

6. Click on Select, and set the attribute class to System Resource and attritube to System OU Name.

7. Operator should be set to is equal to, click on values to choose the desired OU. It should read Domain/OU/ChildOU.

8. Next, Next through the rest of the wizard.

9. The device collection has now been created.
Query Language : 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 SMS_R_System.SystemOUName = "THESYSADMINS.LOCAL/LONDON/LAPTOPS"

No comments:

Post a Comment