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 -
Sergio Belkin wrote:
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.
SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP
2009/10/29 Ivan Kalik <tnt@kalik.net>:
Sergio Belkin wrote:
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.
SELECT Count(*) FROM radacct WHERE UserName='some_username'
Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I guess that you're using database module, aren't you? -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin -
Sergio Belkin wrote:
2009/10/29 Ivan Kalik <tnt@kalik.net>:
Sergio Belkin wrote:
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.
SELECT Count(*) FROM radacct WHERE UserName='some_username'
Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I guess that you're using database module, aren't you?
You should too. Much simpler than parsing detail file. Ivan Kalik Kalik Informatika ISP
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
participants (3)
-
Ivan Kalik -
Scott Miller -
Sergio Belkin