The Sysadmins

Tips and tricks from the Sysadmins

SCCM 2012 – Creating Device Collections

Device collections in System Center 2012 Configuration Manager represent a logical container for a grouping of devices. These collections can then be used to perform a number of tasks, such as deploying software, compliance settings or task sequences. I’ve outlined 4 of the most common collection types below.

Device Collection based on OU

1. Browse to Assets and Compliance, right click on Device Collections and select “Create Device Collection”.

Create Device Collection

2. Give the collection a meaningful name, and set the limiting collection.

Give the collection a meaningful name

3. Add a Query Rule.

Select Query Rule

4. Edit Query Statement.

Edit Query Statement

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

Select new query on the criteria tab

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

Enter the required criteria properties

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

Attribute Class System Resources Attribute System OU Name

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

Rule is complete

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"

Device Collection based on an Active Directory Security Group

1. Follow steps 1-5 from the first example.

2. Click on Select, and set the attribute class to System Resource and attritube to Security Group Name.

Attribute class System Resources Attribute Security Group Name

3. Click on value and choose from one of the populated entries, or manually enter the security group name.

Criteria properties

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

5. 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.SecurityGroupName = "THESYSADMINS\\London Security Group"

Device Collection based on machines with x software installed

1. Follow steps 1-5 from the first example.

2. Click on Select, and set the attribute class to Installed Appliactions and attritube to Display Name.

Attribute class Install Applications Attribute Display Name

3. In this example, I’ve set the operator to “is like” and %java%. This will return any device with Java in the title of add/remove programs.

Value is like Java

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

5. 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 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 "%Java%"

Device Collection with Manual Direct Rules

1. Following steps 1-2 from the first example

2. Add a Direct Rule.

3. Enter a value of the device you wish to add. The device must already be in SCCM, you can confirm this by searching for the device under “Devices”.

Add the value of the device

4. If the device is found you will be able to select it on the next page.

If the device is found, tick and select next

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

6. The device collection has now been created.

You can also manually add devices by right clicking on the collection and selecting Add Resources.

Right click device collection and select add resources

Type in a device name at the top, click search, then select the device in the search results pane and click add and OK.

SCCM_Device_Collections_16

3 Comments

  1. Very good article. Thanks

  2. Thanks for sharing…
    It’s a very useful article!

Leave a Reply

Your email address will not be published.

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.