All Windows Vista Systems

[anyweb]

In SCCM 2007 we have a number of pre-defined Collections such as All Systems, All Users, All Windows XP Systems and so on, however we want to create a new collection to manage our Windows Vista systems.

 

To do this we'll copy an WQL query from a pre-defined collection (All Windows 2000 Professional Systems) and edit it so that it does what we need,

 

start up SCCM configuration Manager console, expand Collections under Computer Management, and select the All Windows 2000 Professional Systems collection, right click on it and choose properties and click on the Membership Rules tab.

 

 

click the Edit Query Statement icon (looks like a hand holding a document)

 

 

click on Edit Query Statement and when you are presented with a results screen click on Show Query Language

 

 

 

This will display the query, mark it choose Copy.

 

 

click ok, cancel, cancel.

[anyweb]

Create New Collection

 

right click on Collections in the SCCM Configuration Manager console, choose New Collection.

 

 

when the New Collection wizard appears, give the collection a name like All Windows Vista Systems fill in the comments and click Next,

 

 

In the membership rules page, click on the New Query Statement icon,

 

 

in the Query Rule Properties, give the rule a name eg: All Windows Vista systems then click on Edit Query Statement

 

 

In the General tab, click on Show Query Language and paste in the code we copied from above.

 

 

Change the value at the end of the query from 5.0 to 6.0 and click Ok, then Ok, then next, next, next and close.

 

 

original query 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 '%Workstation 5.0%'

 

change to this

 

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 '%Workstation 6.0%'

 

 

that's it, you now have a new collection called All Windows Vista Systems

 

 

now that you are done and you know how to make the collection, you can also create one for All Windows Server 2008 systems

 

here's the query for you

 

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.0%'

 

Here's Microsofts Technet page on making Collections.

[moha]

and if the query for windows 7

[Peter33]

and if the query for windows 7

Use 6.1 instead of 6.0

[lightiv]

How about queries for Vista Service Pack 1 & 2 systems?

 

I figured out how to create these collection. Thanks.

Edited December 5, 2012 by lightiv

[anyweb]

How about queries for Vista Service Pack 1 & 2 systems?

 

I figured out how to create these collection. Thanks.

 

so why not share what you found out so others can learn :-)