Re: byte-accounting on customer side

Josh Hillman ( (no email) )
Thu, 23 Apr 1998 13:11:49 -0400

From: Juergen Weiss []
Anybody knows about a freeware/shareware tool to make byte accounting
with Win95 DUN or NT RAS?
Some of my customers like to know how many bytes they "used" within one
month through their dialup-connection to me.

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