Wednesday, May 29, 2013

SCCM Collection query to get 32 bit and 64 bit machines

This WQL query will create a SCCM collection for all the 64 bit Workstations in the organization.
To create a collection for 32-bit workstations, replace the “x64” with “x86”.
*********************************************************************************
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_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemType = "X64-based PC"
*********************************************************************************


More SCCM collection queries can be found here

3 comments:

  1. >To create a collection for 32-bit workstations, replace the “x64” with “X32”.
    You must replace x64 wit x86, not x32.

    ReplyDelete
  2. Thank you for picking up the typo.
    Original article been updated and re-published.

    ReplyDelete
  3. i am using sccm 2012 R2

    I want to create a device collection based on operating system versions like winxp x86, winxp x64, win7x86, win7x64, win8 x86, win8 x64, win8.1 x64 win8.1 x86.

    please do guide me how to create query based collection

    ReplyDelete