I use the following: SELECT SUM(AcctOutputOctets/1024) AS data, SUM(AcctSessionTime/60) AS minutes, DATE_FORMAT(AcctStartTime,'%M %Y') AS month, CalledStationId, UserName INTO OUTFILE "/tmp/feb-09-result.txt" FROM radacct GROUP BY month, CalledStationId, UserName HAVING month LIKE 'February 2009'; Scott -----Original Message----- From: freeradius-users-bounces+srmiller=interbel.net@lists.freeradius.org [mailto:freeradius-users-bounces+srmiller=interbel.net@lists.freeradius.org] On Behalf Of Sergio Belkin Sent: Thursday, October 29, 2009 5:11 AM To: FreeRadius users mailing list Subject: Time connected Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. Thanks in advance! -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html