All calls stats are in the Calls table, so you can select whatever you want
out of there. Here's a script that we use all the time to generate
statistics (we're use Ascend Max NASes also). We very frequently email
these to our customers when they're running into problems (as proof or
whatever). Just enter in the user's username toward the bottom and let it
go. There's a lot more info in the Calls table than what we're extracting
below, but typically the stuff below is sufficient:
/* Call Statistics for a given username */
SELECT "Date/Time At End Of Call"=CallDate,
"Download"=AscendXmitRate,
"Upload"=AscendDataRate,
"Seconds"=AcctSessionTime,
Disconnect=AscendDisconnectCause,
"Max"=Server
FROM Calls, Servers
WHERE IPAddress = NASIdentifier
AND AcctStatusType = 2
AND Username = ''
/* AND CallDate >= '3/1/99' */
ORDER BY CallDate
Josh