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

Bandwidth Utilization Reporting

Has anyone developed a SQL query that would indicate the following for WAN circuit utilization...

1. Period of utilization above a certain percentage (40% in my case).

2. Number of times over utilization has occured in the past week.

We are trying to develop a capacity monitoring system for our redundant circuits. Whenever one reaches consistent 40% usage we would like to begin looking at upgrading the circuit such that if one fails then one would have the capacity to handle two circuits worth of data until the one circuit is repaired. So we want to know when the circuit reaches 40% usage, how long it reached that usage and how many times throughout the week it has occurred.

If anyone has an idea of how to accomplish this and would like to share, it would be greatly appreciated as my SQL skills are virtualy non-existent.

Thanks

Find more posts tagged with

Accepted answers

All comments

pacetti

Do you need a single, all-encompassing SQL query, or would an alert-based scheduled report meet your needs? if the latter will work, the following is a rough outline of the procedure:

Create a node custom property and then apply it to all devices on your WAN circuit.
Create an alert on interface properties using the Advanced Alert Manager with the following simple trigger conditions:
- Interfaces > Current Traffic > Average Xmit+Recv Percent Utilization is greater than or equal to 40
- Network Nodes > Custom Properties as designated previously
Create an Event Log report in Report Writer with the following fields:
- Events > Event Time
- Events > Event Type Name
- Events > Message
Filter your Event Log report with the following simple conditions
- Events > Event Type Name is equal to Alert Triggered
- Network Nodes > Custom Properties as designated previously
Either export the report to Excel for manipulation or use Report Scheduler to send your report by email for regular review

More information about each the tasks in this procedure can be found in the SolarWinds Orion Network Performance Monitor Administrator Guide.

jpnavarrette

I didnt even think of doing it this way. I actually have our SQL developer writing a query for me at the moment.

If I were to do it this way, would I be able to suppress the alerts such that I could log the events but not necessarily create un-necessary alerts for our operations team to decipher?

pacetti

No, I don't believe so. For each event, you'll need an alert to trigger.

afsprau

I see this is an old post, but did you ever find a good way of getting this info without triggering alerts?