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 <br /> SMS_R_System.Name, <br /> SMS_R_System.ADSiteName, <br /> SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, <br /> SMS_R_System.IPAddresses, <br /> SMS_R_System.LastLogonUserName, <br /> SMS_R_System.DistinguishedName <br /> from SMS_R_System <br /> inner join SMS_G_System_X86_PC_MEMORY <br /> on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId <br /> where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory <= 1024000 <br /> order by SMS_R_System.Name, <br /> SMS_R_System.DistinguishedName, <br /> SMS_R_System.ADSiteName, <br /> SMS_R_System.IPAddresses, <br /> SMS_R_System.LastLogonUserName <br />
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.