cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Custom Report Help (CPU/MEM min/max/avg) Business Hrs w/Daily Summary

Hello,

   I have a Application Admin that needs a report showing CPU & Memory min/max/avg for a list of servers.

The data time frame is business hours (0800 - 1700) Monday - Friday for the last 30 days

They just want daily averages for each server

Exported to Excel

example

NodeDate
CPU (min)CPU (max)CPU (avg)MEM (min)MEM (max)MEM (avg)
Server13/19/180533.94.13.9
Server13/20/180303.94.54.0

I cannot seem to achieve this in Report Writer or web-based reports.

Would appreciate any help.

Labels (2)
0 Kudos
3 Replies

Hi mnostrom what you need to do is create a Custom Table and use the Dynamic Query Builder to set out your working hours. Then you can build the report as normal. Here is a KB Link.

Here is my example:

pastedImage_1.jpg

Sorry, excuse my data values this is from my test lab. but hopefully, it shows you enough to replicate it. I have used Vendor to narrow down the devices in the report, you could of course use any other additional filters such as Custom Property, Site, etc.

- David Smith
0 Kudos

dgsmith80​, the image came in super tiny, at least in my browser

mnostrom​, this is how I would do what you have specified

pastedImage_0.png

Obviously filter on custom properties or whatever you have to get your list of servers. 

pastedImage_1.png

Pick your columns out from the selections, I went with Caption, then jump down to the CPU / Memory History section to get all those historical metrics and the timestamp.  Since they don't offer the min/max percent memory used I just added in the average value 3 times, and will change my aggregation type on the next screen.

pastedImage_2.png

Click into one of the 3 instances of avg mem and look for the aggregation, switch it however you need and make sure to rename the column. Repeat for the Max percent mem, arrange the columns how you want them to show up so now I have this

pastedImage_3.png

Jump down to the Time settings and set them like so to break it out per day

pastedImage_4.png

Set the sorting however you like,

pastedImage_5.png

and make sure the group by is set to Caption.  Now you have something like this:

pastedImage_6.png

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

- Marc Netterfield, Github
0 Kudos

Thanks mesverrum I did pretty much the same thing, but without the detailed explanation so great job Not sure what happened with my screenshot, maybe because I was on my MacBook at the time?

- David Smith
0 Kudos