I run several queries through my software (wonderful I must say) that
compiles information into a very detailed analysis for every user and the
different Plans we have (Unlimited and Managed time, quarterly billing,
monthly billing, etc...). I run these every billing cycle and create a
new table in a separate SQL database for each month (this is all
automatic though!). Makes it invaluable to management, finding the trends
in usage and bandwidth utilization for a single user or group of
customers.
At 07:45 PM 3/7/98 +0800, you wrote:
>>>>
<excerpt><smaller>Hello.
</smaller>
<smaller>I just discovered that after rebooting my NT server 4 machine (
also running RadiusNT 1.16.60 ) , RRAS is issuing duplicate
AcctSessionID's again.
</smaller>
<smaller>So, I removed the primary key property the keys in the Calls
table.
</smaller>
<smaller>Things went well.
</smaller>
<smaller>Later, my machine hanged.
</smaller>
<smaller>I rebooted and I looked that the calls table and I saw 4 almost
blank rows, except that they all had the value 7 for their
AcctStatusTypes and the same calldates ( 3/7/98 4:04 pm ).
</smaller>
<smaller>Anyone have any ideas where this came from ? I didn't hear
anyone dial-in that time - or maybe I was just too busy to notice.
</smaller>
<smaller>- Danny Sinang
</smaller>
</excerpt><<<<<<<<