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

Need an SQL Query to get CPU for a subset of hosts

We are front ending SAM 6.2 with a BI tool to consolidate dashboards. I would like to display CPU for a subset of hosts. What woudl the SQL query look like?

Find more posts tagged with

Accepted answers

All comments

HolyGuacamole

Login to the SolarWinds server, launch the Report Writer tool. Build a new report or modify an existing one, Then use the View, Show SQL option to reveal the SQL query that would be used to run the report.

pat_m

This should do what you need

SELECT
Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Nodes.CPULoad AS CPULoad
FROM
Nodes
WHERE
(
(Nodes.CPULoad >= 0)
)

ORDER BY CPULoad DESC