Re: [Emerald] How many ports are used.

Ed Miller ( (no email) )
Tue, 11 May 1999 14:47:56 -0400

Thanks. I am not up on SQL when I put a date 5/10/99 in each x/x/xx
I get a number. 27 what does that mean?

Is there a scrip that gives me names of who is on at any one time?
And when they got on or something like that?


> 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) <=
> 'x/x/x'
> and DateAdd(Second, (0-AcctDelayTime), CallDate) >= 'x/x/x'