I have noticed from the list that you have many, many SQL scripts for many=
Would you be willing to make them available?
*********** REPLY SEPARATOR ***********
On 5/11/99, at 3:12 PM, Josh Hillman wrote:
>Here's a slightly modified one that I've been using for a while.
>The number of people online is simply the number of "row affected"
>DECLARE @datetime char(20)
>SELECT @datetime =3D '5/1/99 9:45pm'
> "Start Of Call"=3DDateAdd(Second, 0-AcctSessionTime-AcctDelayTime,
> "End Of Call"=3DDateAdd(Second, 0-AcctDelayTime, CallDate),
> "Seconds Online"=3DAcctSessionTime,
>WHERE DateAdd(Second, 0-AcctSessionTime-AcctDelayTime, CallDate) <=3D
>AND DateAdd(Second, 0-AcctDelayTime, CallDate) >=3D @datetime
>AND AcctStatusType =3D 2
>ORDER BY CallDate
>From: Dale E. Reed Jr. <email@example.com>
>To: firstname.lastname@example.org <email@example.com>
>Date: Tuesday, May 11, 1999 2:09 PM
>Subject: Re: [Emerald] How many ports are used.
>>Ed Miller wrote:
>>> A while back I had a SQL script that gave me how many
>>> ports were in use at a time I entered into the script.
>>> I have lost it when one of my machines went south
>>> and need it very badly. Does anyone out there have
>>> one that will tell me how many people are on line at
>>> any one time.
>>> I have people that said they could not get in at
>>> night and I need to know if it is the phone co. or
>>> my ports are full.
>>> I suspect that it is a fast busy but I need proof that
>>> my line are not full.
>>diggin into bag 'o scripts...I think this will do:
>>Where DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate) <=3D
>> and DateAdd(Second, (0-AcctDelayTime), CallDate) >=3D 'x/x/x'
>>Dale E. Reed Jr. Emerald and RadiusNT
>>IEA Software, Inc. www.iea-software.com