>iml@interconnect.net wrote:
>>=20
>> old call records
>>=20
>> Dale did I read somewhere that you posted that the call records are
>> not deleted when consolidation is done?
>>=20
>> 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.
If I wanted to add AcctInputOctets, AcctOutputOctets and
AcctTerminateCause how would I add that in. I have the old table
created, however, the old trigger is gone and I really hate to screw
up the calls table trigger.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart