Export multiple node CPU-MEM-DISK stats

Hello,

I'd like to export the following data for a group of servers

Server name

Time stamp

CPU usage

MEM usage

Read latency

Write latency

Where server name starts with 'deptname'

Time between 10/24/16 07:00:00 AM and 10/24/16 17:00:00 PM

ONE MINUTE INCREMENTS

Not sure if a report or a SQL query would be more effective here.

Thanks in advance.

Find more posts tagged with

anyone?

This is kind of sloppy, but just looking to see if this is what you had in mind?

Select Top 50 NodesData.Caption AS Name,Volumes.LastSync AS TimeStamp,CPULoad.AvgLoad

AS 'CPU Usage(%)',CPULoad.AvgPercentMemoryUsed AS 'Memory Usage (%)',Volumes.DiskReads,Volumes.DiskWrites

From Volumes

Join NodesData

ON NodesData.NodeID = Volumes.NodeID

JOIN CPULoad

ON CPULoad.NodeID = Volumes.NodeID

Where Volumes.DiskReads IS NOT NULL

Order by NodesData.Caption,LastSync