[RadiusNT] Re: RadiusNT Digest

New Message Reply Date view Thread view Subject view Author view
Edsonet (administrator@yellowhead.com)
Wed, 20 Dec 2000 07:48:17 -0700

Message-Id: <>
Date: Wed, 20 Dec 2000 07:48:17 -0700
From: Edsonet <administrator@yellowhead.com>
Subject: [RadiusNT] Re: RadiusNT Digest

The simplest method is to run a query against the database to delete
unwanted data. A stored delete query is the most efficient, but we want to
keep the data, so we create a recordeset with all call data greater than 24
hours. The data is then transferred to an off-line database for later
processing and deleted from the active database. This can be set up to run
automatically during non-peak hours.

J.A. Coutts
Systems Engineer
    SQL$ = "SELECT DISTINCTROW Calls.NASIdentifier, Calls.NASPort,
Calls.AcctStatusType, Calls.CallDate, Calls.UserName,
Calls.AcctSessionTime, Calls.FramedAddress, Calls.AcctInputOctets,
Calls.AcctOutputOctets, Calls.ConnectInfo " _
    + "FROM Calls WHERE Calls.CallDate < DateAdd('d', -1, Now())" _
    + "ORDER BY Calls.UserName, Calls.CallDate DESC;"

************** REPLY SEPARATER ****************
At 12:00 AM 12/20/2000 -0800, you wrote:
>.------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
>| Message 4 |
>'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
>Subject: [RadiusNT] Accounting and Authorization logs
>From: Steve Cobb <SteveC@Computer-Geeks.com>
>Date: Tue, 19 Dec 2000 13:52:35 -0500
>Does anyone have a good way of archiving the accounting and authorization
>logs. Ours get very big quickly and I wondered if there is a way to remedy
>this. We manually stopped the radius service, renamed the files, let
>RadiusNT create new files, then zip the old files. I can create a batch
>file to do this and schedule it with at, but I was wondering if there were
>any other suggestions.
>Steve Cobb
>Computer Geeks
>Need faster Internet service?


New Message Reply Date view Thread view Subject view Author view
This archive was generated on Wed Dec 20 2000 - 06:32:39 Pacific Standard Time