If the 95/NT users have keep a logfile for the modem connections, that log
file tracks sent/received bytes in the "session statistics" section toward
the end of each session. The option to enable/disable a logfile is in the
modem properties --> Connection tab --> Advanced --> Record logfile.
Asside from that and I guess other 3rd party applications that track it, we
have it all logged in our Emerald db too. If only a couple people
needed/wanted it, it's not a big deal, but if a lot of people want the
info, then obviously it's better that they track it.
SELECT "Hours Online"=(Sum(AcctSessionTime)/3600),
"Bytes Downloaded"=Sum(AcctOutputOctets),
"Bytes Uploaded"=Sum(AcctInputOctets)
FROM Calls
WHERE UserName = 'someusername'
AND AcctStatusType = 2
AND CallDate >= '3/1/98' AND CallDate < '4/1/98'
Josh Hillman
hillman@talstar.com