1 Reply Latest reply on Nov 16, 2016 9:33 AM by simon.macpherson

    SQL Queries to list Physical Memory


      I want to run a report to list me all Window devices that have less than 4GB's of RAM. What would be the SQL Query Filter for this?

        • Re: SQL Queries to list Physical Memory

          Try this query (replace select objects as required)


          select Caption,SysName,MachineType,IP_Address,LastBoot,SystemUpTime,CPULoad,MemoryUsed,City, round((TotalMemory/1024/1024/1024),0) AS 'RAM in GB

          from nodes (NOLOCK)

          where DeviceRole = 'workstation' and ObjectSubType = 'SNMP'

          and round((TotalMemory/1024/1024/1024),0) <= 4096