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
> 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'
>