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

Creating a bandwidth alert...

I have a report which I created in Report Writer which shows me the top bandwidth users on our WIreless network. I would like to use that same data to create an alert when an individual user goes over a certain total bandwidth in any given 24 hour period. I opened a ticket with Solarwinds but they redirected me here. Does any one have any thoughts? Here's the SQL from the report. I'm not sure how to translate that to create an Alert. Thanks for any information...

SELECT
    TOP 100
    rc.Client_MAC AS MAC_Address,
    rc.NodeID as NodeID,
    rc.Client_Name AS Name,
    AVG((rc.TotalBytesRxPerSec + rc.TotalBytesTxPerSec)) AS AVERAGE_of_Avg_Bps_Rx_Tx,
    AVG(rc.TotalBytesRxPerSec) AS AVERAGE_of_Avg_Bps_Rx,
    AVG(rc.TotalBytesTxPerSec) AS AVERAGE_of_Avg_Bps_Tx,
    SUM((rc.TotalBytesRxDiff + rc.TotalBytesTxDiff)) AS SUM_of_Total_Bytes_Rx_Tx,
    SUM(rc.TotalBytesRxDiff) AS SUM_of_Total_Bytes_Rx,
    SUM(rc.TotalBytesTxDiff) AS SUM_of_Total_Bytes_Tx
FROM NPM_NV_WL_REPORT_CLIENTS_V rc
INNER JOIN Nodes on Nodes.NodeID = rc.NodeID
WHERE
( rc.DateTime BETWEEN DATEADD(day, -1, getdate() ) and getdate() )

GROUP BY rc.Client_MAC, rc.Client_Name, rc.NodeID
ORDER BY 7 DESC

Find more posts tagged with

Accepted answers

All comments

qle

Total <any statistic> usually refers to historical data but alerts are usually meant to react on current data. Quickly glancing over the available statistics to alert on, I don't see any that refers to total traffic for today. Maybe I'm wrong but it doesn't appear to be possible to alert on this.