SCCM query x64 or x86 Operating System

How to create SCCM query, make collections, based on x64 or x86 Operating System


Today I have received a task to run USMT scan estimate with SCCM and generate reports for each computer. USMT scanstate.exe is very strict on system architecture, x86 or x64. So I created to collections and I used query’s for membership rules.

This is the setting using gui:




Of if you prefer the code for 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"