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

[mnostrom]

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

Node	Date	CPU (min)	CPU (max)	CPU (avg)	MEM (min)	MEM (max)	MEM (avg)
Server1	3/19/18	0	5	3	3.9	4.1	3.9
Server1	3/20/18	0	3	0	3.9	4.5	4.0

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

Would appreciate any help.

[dgsmith80]

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:

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.

[mesverrum]

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

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

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

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.

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

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

Set the sorting however you like,

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

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

•                 LinkedIN: Loop1 Systems
•                 Facebook: Loop1 Systems
•                 Twitter: @Loop1Systems

[dgsmith80]

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?