Total bandwidth for a month monitoring and alerting.

[liminyme]

Hi Team,

I need to know is there any options count whole month bandwidth for a device and sent a result to admin mail if it crossed a limit we set.

Thanks!

[Osiris]

I think that this would be a nice enhancement. You could use the Data Source Statistics plugin to take the raw data from the monthly table, and multiply the average by the number of days, and you would get the total bandwidth. You could write it as a host level data query. If you don't have the skills to do such a thing, you could always log a feature request at GitHub, but I'm not sure what the priority would be of the core devs.

Code: Select all

mysql> select * from data_source_stats_monthly where rrd_name like 'traffic%' and average>0 order by average desc limit 10;
+---------------+-------------+-----------------+--------------+
| local_data_id | rrd_name    | average         | peak         |
+---------------+-------------+-----------------+--------------+
|          9316 | traffic_in  | 179850.00095353 | 86727355.659 |
|          3293 | traffic_out | 21549.855379778 | 2233483.6325 |
|         10500 | traffic_out | 21549.498944333 | 2164776.5615 |
|          9861 | traffic_in  | 16443.389257778 | 2228639.0414 |
|         10500 | traffic_in  | 12403.523047444 | 80141.104476 |
|          3293 | traffic_in  | 12403.247745556 | 82537.670067 |
|          3292 | traffic_out | 6922.9262470889 | 9737.5070444 |
|          3292 | traffic_in  | 6922.9262470889 | 9737.5070444 |
|          3260 | traffic_in  | 5035.9956758444 | 376827.79036 |
|            87 | traffic_in  |    5035.9944226 | 367888.83947 |
+---------------+-------------+-----------------+--------------+