SCCM 2012 - WQL Query for machines with 4GB RAM or more
If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this.

 select distinct  
      SMS_R_System.Name,   
      SMS_R_System.ADSiteName,   
      SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory,   
      SMS_R_System.IPAddresses,   
      SMS_R_System.LastLogonUserName,   
      SMS_R_System.DistinguishedName   
 from SMS_R_System  
      inner join SMS_G_System_X86_PC_MEMORY  
      on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId  
 where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 4096000
      order by SMS_R_System.Name,  
      SMS_R_System.ADSiteName,  
      SMS_R_System.IPAddresses,  
      SMS_R_System.LastLogonUserName,  
      SMS_R_System.DistinguishedName

You can change the where value of 4096000 to amend the maximum RAM value being evaluated.

If you have any problems with this query, please leave a comment below.

Labels: , ,