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.

Install and Update Third Party Applications with Patch My PC
Install and Update Third Party Applications with Patch My PC
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.

Where

Criterion Type = Simple Value, Attribute Class = Computer System, Attribute = System Type.

Operator = is equal to, Value = x64-based PC.

 

SCCM Query to create collection for x86 and x64 machines

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 and x64 machines
To group all the x86 devices to one collection use the below query.

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"

 

Still Need Help?

If you need further assistance on the above article or want to discuss other technical issues, check out some of these options.

Prajwal Desai

Prajwal Desai is a technology expert and 10 time Dual Microsoft MVP (Most Valuable Professional) with a strong focus on Microsoft Intune, SCCM, Windows 365, Enterprise Mobility, and Windows. He is a renowned author, speaker, & community leader, known for sharing his expertise & knowledge through his blog, YouTube, conferences, webinars etc.