2009/10/29 Ivan Kalik t...@kalik.net:
Sergio Belkin wrote:
2009/10/29 Ivan Kalik t...@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.
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'
I guess that you're using database module, aren't you?
You
2009/11/3 Ivan Kalik t...@kalik.net:
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'
I guess that you're using
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
2009/10/29 Ivan Kalik t...@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'
Sergio Belkin wrote:
2009/10/29 Ivan Kalik t...@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
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';
7 matches
Mail list logo