Daily port usage alarm

Help
1

Hi,
I have a customer using LTE modems, who would like a daily alarm if a port uses more than 4GB. I set up monthly traffic bills and an alert rule for percentages based on monthly use, but I can’t seem to get it to work for daily.

I have tried manually setting the port speed to 4GB and then creating an alert rule for macros.port_usage_percent >= 90 and then setting the delay to 1 day.
Unfortunately no alarms were generated. I also tested this with 1GB as I know the ports are using more that that every day and still no alarms.

I’ve also tried the sql below trying to alarm for 1GB in this case and still generated no alarms.

SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) >= 16777216 AND (ports.ifOperStatus = “up” && ports.ifAdminStatus = “up” && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1

as of 07/30/21, I ran dialy.sh and validate.php returns no errors.

Any help would be greatly appreciated.
thanks,
matt

2

Am I asking this question in the wrong area, or maybe in the wrong format?
Alternatively, is what I am asking for impossible?
I am just trying to understand why the zero comments.

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.