Guys, I found the right code from the Daloradius /sql/counter.conf. In all my googling I have not seen it like this. I found it a little tough when the wiki and Github show code that does not work for a daily-max-session. I guess there is a reason but loads of the examples out there simply don't work unless the radacct table is already populated, cheers. sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = daily query = "SELECT IFNULL(SUM(acctsessiontime - \ GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)),0) \ FROM radacct WHERE username = '%{%k}' AND \ UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b'" Regards Jim