Re: Script Needed PLEASE!
Dale E. Reed Jr. ( (no email) )
Tue, 03 Feb 1998 00:46:19 -0800
John Lange wrote:
> 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,
Mins=(AcctSessionTime/60), Stop=DateAdd(Second, (0-AcctDelayTime), CallDate)
From Calls c
Where Username = 'user'
Order By NASIdentifier, NASPort
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com