Jump to content


  • 0
anyweb

All Windows Vista Systems

Question

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,

 

open_existing.jpg

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.

 

membership_rules.jpg

 

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

 

edit_query_statement.jpg

 

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

 

 

show_query_language.jpg

 

This will display the query, mark it choose Copy.

 

copy_query.jpg

 

click ok, cancel, cancel.

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Create New Collection

 

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

 

new_collection.jpg

 

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

 

collection_general_tab.jpg

 

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

 

new_query_statement.jpg

 

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

 

new_query_rule.jpg

 

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

 

new_general_tab.jpg

 

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.

 

query_language_paste.jpg

 

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

 

6.jpg

 

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

 

found_systems.jpg

 

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.

Share this post


Link to post
Share on other sites

  • 0

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 :-)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.