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

Need help with creating a report.

I need to create a report containing the cpu and memory utilization on a weekly basis but by day and only for our production hours 6am to 4pm.

Find more posts tagged with

Accepted answers

All comments

ecklerwr1

I've done something similar on my NPM. The tough part for me was the business hours part... here's how i did it:

Select fields Node Name, Machine Type, Average CPU Load (descending) function avg., Peak CPU load (descending) function max.

Filter Results where all of the following:

Time of Day (24 hour format) is greater than or equal to 05:00

Time of Day (24 hour format) is less than or equal to 16:59

Day of the Week is greater than or equal to Monday

Day of the Week is less than or equal to Friday

Day of the Week is not equal to Saturday

Day of the Week is not equal to Sunday

Vendor is equal to windows (I change this for other things like Cisco, Linux, Sun, VMware, etc.)

Time Frame Named Time Frame Last 7 Days (for you it would be for a 7 days and then summarized daily)

I hope that makes sense... this is in report writer by the way ;^}

I do another separate report for memory utilization but you could combine it all in one. Also my time frame is from 5am to 5pm here but you can change that to fit your needs.

mr.e

ecklerwr1,

Your report setup looks very good. However, I would remove the following two clauses:

Day of the Week is greater than or equal to Monday

Day of the Week is less than or equal to Friday

This since you've already excluded Saturday and Sunday on the following two clauses, which should do the trick. So, it seems a bit redundant, even if it works. Just a thought...

95redfxds

Thanks guys those answers make sense now. I will just have to tweak them a little.

Again thanks for you help.

ecklerwr1

I kinda thought the same thing... I was just worried somehow Sat and Sunday might sneak in... We run lots of backup jobs to some remote sites and it pegs utilization at close to 100%. I don't care about that so during the day is the time I really am worried about utilization, cpu, and memory loading.

95redfxds

The problem is that I need the memory utilization along with the cpu loads and using the Date/Time parameters in the filter results grabs all the nodes in our network, ie, desktops, routers, etc., not just our production servers. I'm beginning to think I might have to do via sql, which wouldn't be pretty. Any other ideas?