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

Bandwidth utilization during working hours

Is there a way to get average utilization and max min for just working hours rather than averaging 24 hours? Trying to figure out how to do is.

-=Dan=-

Find more posts tagged with

Accepted answers

brian_duvall

No problemo. This report will give 95th Percentile data per circuit (inbound/outbound) and will do it based on local site business hours (8am to 6pm) Monday thru Friday. You can adjust the time of business hours as well as what days of week to ignore.

I have uploaded a zip file that contains my report as well as the functions that are needed to make it work. I also put a screenshot of how my custom properties look so you can model after them.

Here is the link to the zip file:

All comments

pacetti

smartd,

You may find this KB article helpful for creating such a report.

brian_duvall

If you are a global organization and have offices in different time zones it will require a bit more work. I use custom attributes on the interfaces that I care about and store the value in hours in relation to GMT timezone. For instance one office could be -3 and another could be +3 depending on its relation to GMT time. I set all my solarwinds pollers to poll in GMT. Then I wrote custom SQL reports that show 95th percentile data for business hours during the week by offsetting the custom attribute based on the GMT time stored in the database for each circuit.

Chandru

Hi Brian,

It would be really helpful if you could share your information on how to achieve this with Orion

regards

Chandru

smartd

I agree with Chandru. I'd love to see your SQL report

brian_duvall

I have uploaded a zip file that contains my report as well as the functions that are needed to make it work. I also put a screenshot of how my custom properties look so you can model after them.

Here is the link to the zip file:

smartd

Thanks

Chandru

Hi Brian, Thanks for sharing the report!! Much appreciated

Can you please clarify this error with monthbegin and monthend?

Msg 102, Level 15, State 1, Procedure monthBegin, Line 6
Incorrect syntax near '@now';.
Msg 137, Level 15, State 2, Procedure monthBegin, Line 25
Must declare the scalar variable "@ret".

I am not SQL expert

Thanks

Chandru