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
At 07:45 PM 3/7/98 +0800, you wrote:
<smaller>I just discovered that after rebooting my NT server 4 machine (
also running RadiusNT 1.16.60 ) , RRAS is issuing duplicate
<smaller>So, I removed the primary key property the keys in the Calls
<smaller>Things went well.
<smaller>Later, my machine hanged.
<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>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>- Danny Sinang