SCCM Query to create collection for x86 and x64 machines In this post you will find the SCCM Query to create collection for x86 and x64 machines. Device collections in System Center 2012 Configuration Manager represent a logical container for a grouping of devices. These collections can then be used to perform a number of tasks, such as deploying software, compliance settings or task sequences. If you have the SCCM setup in your organization and if you are asked to group x64 machines and x86 machines to a separate collection then you can use the queries listed in this post so that your work gets done quickly. Query based collections allow an administrator to provide any criteria that the SCCM database may hold about systems, and automatically make those systems a member of that collection.
To group all the x64 devices to one collection use the below query.
SCCM Query to create collection for x64 machines
select * 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"
If you don’t want to use the above query and if you want to manually create the SCCM query to create collection x64 machines then below the screenshot should help you.
Criterion Type = Simple Value, Attribute Class = Computer System, Attribute = System Type.
Operator = is equal to, Value = x64-based PC.
When you check the Query Statement Properties, under Criteria you should find the data similar to below screenshot.
SCCM Query to create collection for x86 machines
select * 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"