Creating Query Based Collection in SCCM 2007

Query Based Collection:

1. In the Configuration Manager console, navigate to System CenterConfiguration Manager / Site Database / Computer Management

From Collections Actions menu click NewCollection. A new collection wizard will open up, enter the collection name and description.

 

  2.Click on ‘yellow’ colored button as shown that will pop up “query rule properties” window where you can enter the appropriate name and query.

Here, I am creating a collection based on the query to find out all the Windows XP machines.

There are few other points to note here

·     Update this collection on a schedule-when this option is checked, it will update the collection on the specified schedule

·     Dynamically add resources- this option is new in SCCM 2007 R3. When this option is checked, the collection will be dynamically add resources as and when the requirement is met with the query

·     Limit to collection: We can limit the collection to other collections so that the resources are discovered only in the limited collection.

·     Enter the query rule name :

·     Click on Edit Query Statement to proceed further.

3. Click on “show query language” to input the query.

4. Enter the appropriate query:

Here, the query is to find out the machines with the Windows XP Operating system.
Click OK, click Next , next , next and close the wizard

 

5.Update Collection membership:

After the collection is created, we need to update the collection so that the collection is populated with the resources.
Here, the Windows XP machine in the lab is appearing once I updated the collection membership.