Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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?

Find more posts tagged with

sql query

Accepted answers

All comments

simon.macpherson

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

Quick Links