Re: Script Needed PLEASE!

Dale E. Reed Jr. ( (no email) )
Tue, 03 Feb 1998 00:46:19 -0800

John Lange wrote:
>
> HI
>
> Rather than re-invent the wheel, I am sure one of you have already written
> this, or could throw it together real quick.
>
> I need a script that will query the Emerald database and run under WebSite
> Pro 1.1h on NT 4.0 sp3, and create a web page with the following...
>
> "username" "NAS" "port" "time on or log in time"
>
> Indexed by "location" "NAS" "port"
>
> NO eMail address, NO ip address, just the above info. Or any good sugestions.
>
> Thanks much, I couldn't code anything more complex than a simple batch file.

There are several of these in the /emerald/contrib dirs (like cf and idc).
Basically, you are looking for:

Select UserName, NASIdentifier, NASPort, Start=DateAdd(Second,
(0-AcctSessionTime-AcctDelayTime), CallDate),
Mins=(AcctSessionTime/60), Stop=DateAdd(Second, (0-AcctDelayTime), CallDate)
From Calls c
Where Username = 'user'
AND AcctStatusType=2
Order By NASIdentifier, NASPort

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com