I would like to ignore bandwidth usage between 2 and 5 am.<br><br>        sqlcounter counterChilliSpotMaxTotalOctetsDaily {<br>                        counter-name = ChilliSpot-Max-Total-Octets-Daily<br>                        check-name = CS-Total-Octets-Daily<br>
                        counter-type = data<br>                        reply-name = ChilliSpot-Max-Total-Octets<br>                        sqlmod-inst = sql<br>                        key = User-Name<br>                        reset = daily<br>
                        query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct 
WHERE UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > 
UNIX_TIMESTAMP(CONCAT(CURDATE(),' ', '00:00:00')) AND 
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime NOT BETWEEN 
UNIX_TIMESTAMP(CONCAT(CURDATE(),' ', '02:00:00')) AND 
UNIX_TIMESTAMP(CONCAT(CURDATE(),' ', '05:00:00'))"<br>        }<br><br>Should I do it all in the SQL like that? or does someone have a better idea.<br>