57,3 → 57,14 |
reset = monthly |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" |
} |
|
sqlcounter counterCoovaChilliMaxAllTotalOctets { |
sql_module_instance = sql |
counter_name = CoovaChilli-Max-All-Total-Octets |
check_name = CoovaChilli-Max-Total-Octets |
counter_type = data |
reply_name = CoovaChilli-Max-Total-Octets |
key = User-Name |
reset = never |
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}'" |
} |