Re: [Emerald] PC-Transact_it

Dale E. Reed Jr. ( (no email) )
Thu, 10 Jun 1999 12:54:30 -0500

> Jeff Hopkins wrote:
> Hi Dale, just curious when batch-in support will be enabled for
> PC-transact_it? Also, could I get a copy of the SQL script that is
> used to extract the TS-Graph data? I want to use Crystal Info to
> automatically publish this data on a daily basis.

If you have batch in information for it, please send it to me. If
I remember right, there was an issue with not being able to correlate
out/in transactions, so a batch in was not possible.

There is some additional logic done in the client itself for this,
but here is the basic query:

SELECT NASPort, Calls=Count(Username), Hours=(Sum(AcctSessionTime)/3600)
FROM Calls c, Servers s
WHERE c.NASIdentifier=s.IPAddress and s.ServerID = x
AND DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate) >= 'y'
AND DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate) <= 'z'
AND AcctStatusType=2 AND NASPort >= 0
Group By NASPort

Where x is the serverid, y is the startdate, and z is the enddate.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.