Re: [RadiusNT] Stopping start records

Josh Hillman ( (no email) )
Mon, 19 Jul 1999 16:55:46 -0400

From: Dan Waldron <>
is there any way to stop our Ascend box from sending start records into our
We use the stop record and connect times to work everything out, and if we
only had stop records, we could use the seesion ID as a primary key in the

If you're trying to keep your Calls table from getting cluttered with the
Start records, your best bet is to clear some out every night (automated
task) rather than prevent them from going into the system in the first
place. I have the following Scheduled Task set to run every night (very
early morning) that clears out any Start records and any null entries that
are over 3 days old:

WHERE (AcctStatusType = 1 OR UserName = 'null')
AND DateDiff(Day, CallDate, GetDate()) > 3


For more information about this list (including removal) go to: