If you have allready added the columns to the calls & serverports table then
you should only need to modify the 'calls_insert' trigger to include
"sp.AscendDisconnectCause = i.AscendDisconnectCause".
ie something like...
UPDATE ServerPorts SET
sp.UserName = i.UserName,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = i.CallDate, sp.FramedAddress = i.FramedAddress,
sp.AscendDisconnectCause = i.AscendDisconnectCause
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND s.ServerID = sp.ServerID AND sp.Port
= i.NASPort
Depending on how you look at this info you may also need to adjust the
"callsonline" view to select a meaningfull description for the disconnect
cause value from 'radvalues' or some other refrence table.
Regards,
Cameron
-----Original Message-----
From: Daniel Franks <franksd@redrivernet.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Friday, October 29, 1999 3:19 AM
Subject: RE: [RadiusNT] What about writing CalllerID, AcctSessionID to
callsonline (serverports) ?
>Hi,
>
>I have been trying to figure this out for awhile now, but have yet to
>suceed. Could you tell me what tables you modified and with what info?
>Also if you could send a copy of your trigger that would be really cool. I
>am trying to add AscendDisconnectCause, so I added it to the ServerPorts
and
>Calls table, and attempted to update the trigger. Nada, it doesn't work.
>
>Thanks for any help you can provide.
>
>Dan Franks,
>Red River Communications, Inc.
>http://www.redrivernet.com/
>franksd@redrivernet.com
>
>
>
>-----Original Message-----
>From: radiusnt-request@iea-software.com
>[mailto:radiusnt-request@iea-software.com]On Behalf Of Cameron Westlake
>Sent: Thursday, October 28, 1999 12:51 AM
>To: radiusnt@iea-software.com
>Subject: Re: [RadiusNT] What about writing CalllerID, AcctSessionID to
>callsonline (serverports) ?
>
>
>Hi Serkan
>
>Using MSSQL's enterprise manager, you can easily alter the serverports
table
>to include the new columns and then update the insert trigger on the calls
>table.
>
>We find that 'connect-speed' is another handy one to see in the calls
online
>list.
>
>Regards,
>Cameron
>
>
>-----Original Message-----
>From: Serkan SUBASI <ssubasi@turk.net>
>To: radiusnt@iea-software.com <radiusnt@iea-software.com>
>Date: Thursday, October 28, 1999 3:30 PM
>Subject: [RadiusNT] What about writing CalllerID, AcctSessionID to
>callsonline (serverports) ?
>
>
>>What about writing CalllerID, AcctSessionID to callsonline (serverports) ?
>>Because we never know a user s CallerID, unless user disconnects, and
>>queries made to calls table is slower than those made to serverports
>>
>>thanks in advance
>>
>>Serkan SUBASI
>>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart