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
Store

MAX CPU with timestamp

Hi Thwacksters!

I'm trying to write a report that shows the Max CPU for a node during a time period. I want to show when this max value occurred.

Finding the max is easy, however when I add a timestamp in I don't get anything useful;. (I'm aggregating over a week in this case.) Even changing the timestamp format doesn't seem to force it to show up correctly, I get a constant value of "12" or "13" rather than the MM:DD:hh:mm I want!

Thanks for any ideas.

Find more posts tagged with

Accepted answers

All comments

ctlswadmin

Can you provide the syntax your using please.

mesverrum

I came up with this, using SWQL but it wouldn't be hard to adjust to use SQL

SELECT n.caption, peak.maxload, (select top 1 datetime from orion.CPULoad cpu2

where cpu2.DateTime> addday(-7,GETUTCDATE()) and cpu2.NodeID=n.nodeid

) as time

FROM Orion.Nodes n

join (select cpu.nodeid, max(cpu.MaxLoad) as MaxLoad

from orion.CPULoad cpu

where cpu.DateTime> addday(-7,GETUTCDATE())

group by cpu.nodeid

) peak on peak.nodeid=n.nodeid