SCCM 2012 - WQL Query for Machines with less that 1GB RAM
If you need to identify machines within your SCCM environment that have a certain amount of RAM or less, you can use the following WQL query to do this.

 select   
      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 <= 1024000  
           order by SMS_R_System.Name,  
           SMS_R_System.DistinguishedName,  
           SMS_R_System.ADSiteName,  
           SMS_R_System.IPAddresses,  
           SMS_R_System.LastLogonUserName

You can change the where value "1024000" to the amount of RAM that you are looking for.

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

Labels: , ,