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. www.iea-software.com