« Merry Christmas and a great 2010Register today for the Microsoft Management Summit (MMS) 2010 »

Where is my All Windows 7 Systems collection?

12/23/09 | by Jannes Alink [mail] | Categories: System Center, ConfigMgr

When you install ConfigMgr 2007 RTM/SP1 some basic collections are created like; All Windows Server Systems, All Windows XP Systems and so on.

To be able to fully support Windows 7 systems with ConfigMgr you need to apply Service Pack 2. This Service Pack is however not creating a basic collection named All Windows 7 Systems.

You can create this collection manually. To automatically fill the collection you need to create a query based membership rule. You can use the following query:

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.OperatingSystemNameandVersion like "%Workstation 6.1%" or SMS_R_System.OperatingSystemNameandVersion like "%Windows 7%"

As you can see I specified two criteria; ‘Workstation 6.1’ and 'Windows 7'.

Enjoy!

Permalink

Search



Hi,

I'm Jannes Alink and welcome to my blog! I'm living in the Netherlands and working in the IT industry for more than 8 years. I work as freelance consultant at Alinja and deliver projects around the globe. Currently on a project in Abu Dhabi (UAE).

Posts are just my personal opinion.

February 2012
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29        

XML Feeds

powered by b2evolution free blog software