All Windows 7 x64 and Windows 7 x86 Workstations Query

Create Collection For Windows x64 and x86

WQL for Windows 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_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC"


WQL for Windows 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_G_System_COMPUTER_SYSTEM.SystemType = "x86-based PC"