Re: [RadiusNT] Stopping start records

Josh Hillman ( (no email) )
Tue, 20 Jul 1999 12:59:56 -0400

> Josh Hillman wrote:
> >
> > From: Dan Waldron <dan@internetworx.com.au>
> > 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:
> >
> > DELETE FROM Calls
> > WHERE (AcctStatusType = 1 OR UserName = 'null')

From: Dale E. Reed Jr. <daler@iea-software.com>
> Just leave off this part:
>
> > AND DateDiff(Day, CallDate, GetDate()) > 3

I left that in there so that I had a couple days leighway incase I needed
them for anything (I have on occasion). Three days' worth of the records
doesn't amount to much in comparison to the overall size of the Calls table
anyway.

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart