* This is the VOP Radius mailing list * Maybe this would work for you? SELECT TOP 10 DATEADD(second, - AcctSessionTime, LogDate + LogTime) AS StartTime, LogDate + LogTime AS EndTime, * FROM Accounting WHERE (AcctSessionTime > 0) AND (FramedAddress = 'xxx.xxx.xxx.xxx') ORDER BY starttime
It gives you a starttime based on endtime - acctsessiontime where endtime is logdate + logtime - Del > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of WMOL Administration > Sent: Monday, July 14, 2003 11: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.
