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

Writing a report. Help needed

I am trying to write a report where I can pull weekly data on cpu and memory usage. I would like the output to be broken into hourly periods. So what I am looking for is something like this

Servername time memory usage cpu usage

thanks

-Pat

Find more posts tagged with

Accepted answers

All comments

silverbacksays

You'd need to write a custom SQL query to get this information out, as I don't believe you'll be able to do it using the web report resources.

On the other hand, you could probably achieve this by looking at the memory and CPU usage graphs, clicking export, changing the intervals and time periods and then clicking 'show chart data'.

Depending on how many nodes you need this detail for, will define which one of the two options you go for

joe.tran

I believe this will get you what you need. Set up your Custom Table with the appropriate filter. Then under EDIT TABLE, add the following columns:

Report Columns.png

For some reason, my instance defaulted the "Average Percent Memory Used" column to bytes ヽ(。_°)ノ. So change that back to percentage and lastly set the Sample Interval to "Hour":

Report Columns 2.png

Good hunting!

pat_m

Thanks guys for the help.