/* 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,
CallDate),
"End Of Call"=DateAdd(Second, 0-AcctDelayTime, CallDate),
"Seconds Online"=AcctSessionTime,
FramedAddress
FROM Calls
WHERE DateAdd(Second, 0-AcctSessionTime-AcctDelayTime, CallDate) <=
@datetime
AND DateAdd(Second, 0-AcctDelayTime, CallDate) >= @datetime
AND AcctStatusType = 2
ORDER BY CallDate
Josh Hillman
hillman@talstar.com
----------
> From: Robert H. Clugston <robert@csnsys.com>
> 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='127.0.0.1'
> order by calldate
>
> When I plug in the required information it comes back with sessionID's
and
> times. Can someone give me a script to find the username that was on at a
> certain time?
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com