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 <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')
Just leave off this part:
> AND DateDiff(Day, CallDate, GetDate()) > 3
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart