Windows 7 SCCM Collection Queries

2017-12-11T14:37:20+00:00 April 27th, 2011|Windows|

Here are 2 useful queries which will allow you to create separate x86 and x64 Windows 7 SCCM collections which will come in handy when your pushing out programs that are architecture specific.

Windows 7 x86

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_R_System.OperatingSystemNameandVersion like “%Workstation 6.1%” or SMS_R_System.OperatingSystemNameandVersion like “%Windows 7%”) and SMS_G_System_COMPUTER_SYSTEM.SystemType = “x86-based PC”

Windows 7 x64

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_R_System.OperatingSystemNameandVersion like “%Workstation 6.1%” or SMS_R_System.OperatingSystemNameandVersion like “%Windows 7%”) and SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC”