Re: Retrieving Information from Radius Logs

Josh Hillman ( (no email) )
Thu, 7 May 1998 14:12:46 -0400

Just change the date/time in the third line to whatever you need it to be:

/* Who was online at any given point in time */
DECLARE @datetime char(20)
SELECT @datetime = '4/25/98 10:17PM'
SELECT Username,
/* "Date/Time at end of call"=CallDate, */
"Start Of Call"=DateAdd(Second, 0-AcctSessionTime-AcctDelayTime,
"End Of Call"=DateAdd(Second, 0-AcctDelayTime, CallDate),
"Seconds Online"=AcctSessionTime,
FROM Calls
WHERE DateAdd(Second, 0-AcctSessionTime-AcctDelayTime, CallDate) <=
AND DateAdd(Second, 0-AcctDelayTime, CallDate) >= @datetime
AND AcctStatusType = 2

Josh Hillman

> From: Robert H. Clugston <>
> Dear List,
> I'm trying to track a newgroup spammer from my network. I was once given
> the following script to retrieve information from radius logs:
> Select * From Calls Where DatePart(Month, CallDate)=5 and DatePart(Day,
> CallDate)=5 and DatePart(Year, CallDate)=1998 and
> FramedAddress=''
> order by calldate
> When I plug in the required information it comes back with sessionID's
> times. Can someone give me a script to find the username that was on at a
> certain time?
> ----------------------------------------------------------
> Emerald Mailing List