Re: [Emerald] Radius Error log

Dale E. Reed Jr. ( (no email) )
Thu, 01 Jul 1999 11:38:52 -0700

Guillaume Pavy wrote:
>
> Does a radius error log report only for the last week (sorted with the most
> recent calls first) exist ?

If you put one wek agos date in for the Radlogs search, the printout
will
only contain that.

> If yes, where can it be found ?
> If no, how can flush the database to avoid that all the error logs are kept
> in it ?

There is a task in insttasks that runs the trimlogs stored procedure
once
a night to do this, but it defaults to two weeks. You can can the
trimlogs
to 7 days and make sure you have the task running. It also gets rid of
duplicate entries:

CREATE PROC TrimLogs AS
Delete From RadLogs Where DateDiff(Day, LogDate, GetDate()) > 7

Select RadLogMsgID, Username, Data, LastLogDate=max(LogDate),
Numb=Count(*)
Into #tmp_work