We have been asked on a number of occasions how to create Configuration Manager Collections for machines on x86 or x64 Windows Operating Systems.

To do this, you should use the two collection queries as below:

INSTRUCTIONS

Query to create collection for x86 machines

 select distinct 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"

Query to create collection for x64 machines

 select distinct 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"