SCCM Query to create collection for x86 and x64 machines

Prajwal Desai
Posted by Prajwal Desai

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.

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"

 

Share This Article
Prajwal Desai
Posted by Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Intune and SCCM. He writes articles on SCCM, Intune, Windows 365, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
11 Comments