Re: [RadiusNT] Stopping start records

Dale E. Reed Jr. ( (no email) )
Mon, 19 Jul 1999 16:26:20 -0700

Josh Hillman wrote:
> From: Dan Waldron <>
> is there any way to stop our Ascend box from sending start records into our
> database.
> 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
> database.
> 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')

Just leave off this part:

> AND DateDiff(Day, CallDate, GetDate()) > 3


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

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