* This is the VOP Radius mailing list * Here is what I use. Just change the date and IP. It works for 90%+ of the calls we get. The fields may vary for you, the is what I use with Platypus.
SELECT username, callstart, callend, FROM radiusdat where ipaddress='xxx.xxx.xxx.xxx' and callstart >='01/01/01 00:00:00' and callstart <='01/01/01 23:59:59' order by callstart asc" > * This is the VOP Radius mailing list * > This is exactly what I'm running into here. We have 8 hour session limits > but it's still a mess. > > Scot > > ----- Original Message ----- > From: "Lindsey, Randy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 14, 2003 8:29 PM > Subject: [VOPRadius] Log Analyzer > > > * This is the VOP Radius mailing list * > I started down this road once, but once I figured out what needed to > happen, I decided I didn't want the info that badly. The trouble is > that an user can stay logged in for any length of time (at least in our > environment where we also sell dedicated dialup's that can be on 24x7 > for months at a time). Unless you're capturing watchdog entries (are > those in the database?). > > So if you want a snapshot of who was logged in at, say, 10am 6/30/03, > you have to run through all the logons, then subtract all the > logoffs...not something I can think how to do in an SQL statement. Am I > missing something? > > Randy Lindsey > Colorado Information Technologies, Inc. > http://www.coinfotech.com > > > > -----Original Message----- > From: WMOL Administration [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2003 10:26 AM > To: [EMAIL PROTECTED] > Subject: [VOPRadius] Log Analyzer > > > * This is the VOP Radius mailing list * > Greets, > Anybody know of an easy way to see who was on at a specific time? We > are attempting to cooperate with the local law here and they need who > was on at a few specific dates / times. I can manually scan the logs for > those times but it doesn't really give me the full scope of things since > someone could of logged on 2 hours earlier, etc... > > TIA, > Scot > > > ** > To leave this list, send an email to [EMAIL PROTECTED] and > put the word "LEAVE" in the BODY of the email. > > ** > To leave this list, send an email to [EMAIL PROTECTED] > and put the word "LEAVE" in the BODY of the email. > > > ** > To leave this list, send an email to [EMAIL PROTECTED] > and put the word "LEAVE" in the BODY of the email. ** To leave this list, send an email to [EMAIL PROTECTED] and put the word "LEAVE" in the BODY of the email.
