Time connected

Scott Miller srmiller at interbel.net
Thu Oct 29 16:40:43 CET 2009


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 at lists.freeradius.org
[mailto:freeradius-users-bounces+srmiller=interbel.net at 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




More information about the Freeradius-Users mailing list