Re: [Emerald] detailed calls

Dale E. Reed Jr. ( (no email) )
Tue, 16 Nov 1999 21:44:00 -0800

iml@interconnect.net wrote:
>
> old call records
>
> Dale did I read somewhere that you posted that the call records are
> not deleted when consolidation is done?
>
> If so, this would leave us a history to check against, however, I
> believe one of the tasks in the insttask may delete them...is that
> what Trim Logs does now or no? The reason I am asking is because I
> want to have a detailed history I can query on exact call dates and IP
> addresses.

If you want to have a parallel table that is smaller and faster to
query than the calls table, check out this script:

ftp://ftp.iea-software.com/RadiusNT/MSSQL/calldetails.sql

It creates a CallDetails table and modifies the calls table trigger
to insert into it as well.

-- 

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