Re: [Emerald] How many ports are used.

PowerNet ( (no email) )
Tue, 11 May 1999 15:50:26 -0400


I have noticed from the list that you have many, many SQL scripts for many=
different purposes.
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'
>SELECT Username,
> "Start Of Call"=3DDateAdd(Second, 0-AcctSessionTime-AcctDelayTime,
> "End Of Call"=3DDateAdd(Second, 0-AcctDelayTime, CallDate),
> "Seconds Online"=3DAcctSessionTime,
> FramedAddress
>FROM Calls
>WHERE DateAdd(Second, 0-AcctSessionTime-AcctDelayTime, CallDate) <=3D
>AND DateAdd(Second, 0-AcctDelayTime, CallDate) >=3D @datetime
>AND AcctStatusType =3D 2
>ORDER BY CallDate
>Josh Hillman
>-----Original Message-----
>From: Dale E. Reed Jr. <>
>To: <>
>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:
>>Select count(*)
>>From Calls
>>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.