Ahhhh, you never added the extra columns to the Calls table.
Here are a few of the ones that I added that are related to Ascend:
Column_name Type Length Nullable
----------------------- ---- ------ --------
AscendXmitRate int 4 yes
AscendDataRate int 4 yes
AscendDisconnectCause int 4 yes
AscendConnectProgress int 4 yes
AscendModemSlotNo int 4 yes
AscendModemPortNo int 4 yes
AscendMultilinkID int 4 yes
AscendNumInMultilink int 4 yes
AscendPreInputOctets int 4 yes
AscendPreOutputOctets int 4 yes
AscendPreInputPackets int 4 yes
AscendPreOutputPackets int 4 yes
AscendPreSessionTime int 4 yes
You'll also have to add attributes to your RadAttributes table.
Here's the info for all attributes starting with "Ascend":
RadAttributeID RadVendorID RadVendorType Type Name
-------------- ----------- ------------- ----------- --------------------------------
255 0 0 1 Ascend-Xmit-Rate
197 0 0 1 Ascend-Data-Rate
195 0 0 1 Ascend-Disconnect-Cause
196 0 0 1 Ascend-Connect-Progress
121 0 0 1 Ascend-Modem-SlotNo
120 0 0 1 Ascend-Modem-PortNo
187 0 0 1 Ascend-Multilink-ID
188 0 0 1 Ascend-Num-In-Multilink
190 0 0 1 Ascend-Pre-Input-Octets
191 0 0 1 Ascend-Pre-Output-Octets
192 0 0 1 Ascend-Pre-Input-Packets
193 0 0 1 Ascend-Pre-Output-Packets
198 0 0 1 Ascend-PreSession-Time
> At 12:11 AM 4/3/2000 -0400, you wrote:
> >From: Randy Martin <IEAEmerald@austintx.net>
> > > Is there any way to change the info that's stored in the calls.ConnectInfo
> > > and the calls.AcctTerminateCause columns in the database, like maybe
> >modify
> > > a trigger or something so that these columns hold some information that is
> > > meaningful to Ascend users?
> >
> >I don't know of a way to make ConnectInfo useful for Ascend users, but you
> >can alter the RadAttributes table and Calls table so that
> >"AscendDisconnectCause" acts as AcctTerminateCause. Keep in mind though,
> >Emerald will try to convert the integer to the verbal cause and it uses the
> >causes associated with AcctTerminateCause, which is not the same as
> >AscendDisconnectCause.
> >
> >We don't bother using the Time-On feature of Emerald because it doesn't show
> >enough useful information for Ascend users. I wrote my own SQL script that
> >displays all sorts of handy info and we use it quite frequently. Here it is
> >(just enter in a username between the quotes in the second line, then
> >execute it in ISQL ("Query Analyzer" in SQL 7). I have another script
> >that's identical to this, except it also includes the verbal disconnect
> >causes that I have stored in another table I created in the database that
> >includes all known AscendDisconnectCauses (I have 74 different ones):
> >
> >
> >DECLARE @Username varchar(32)
> >SELECT @Username = ''
> >
> >PRINT ' "Down/Upload" = initial connection speeds'
> >PRINT ' "Duration" = hours : minutes : seconds'
> >PRINT ''
> >SELECT 'End of session' = convert(varchar(20), CallDate),
> > 'Down/Upload' = convert(varchar(5), AscendXmitRate) + ' / ' +
> > convert(varchar(5), AscendDataRate),
> > 'Duration' = /* hours */
> > convert(char(2),
> > AcctSessionTime/3600)
> > + ':' +
> > /* minutes */
> > convert(char(2),
> > AcctSessionTime/60
> > - 60 * (AcctSessionTime/3600))
> > + ':' +
> > /* seconds */
> > convert(char(2),
> > AcctSessionTime
> > - 3600 * (AcctSessionTime/3600)
> > - 60 * ((AcctSessionTime/60) - 60 *
> >(AcctSessionTime/3600))),
> > 'NAS' = convert(varchar(5), s.Server),
> > CallerID = convert(varchar(10), isnull(CallerID, '')),
> > Disc = convert(char(3), AscendDisconnectCause)
> >FROM Calls c, Servers s
> >WHERE c.NASIdentifier = s.IPAddress
> >AND AcctStatusType = 2
> >AND Username = @Username
> >/* AND CallDate >= '3/1/2000' */
> >Order By CallDate Desc
> >
> >
> > > At 10:27 PM 4/2/2000 -0400, you wrote:
> > > >From: Randy Martin <IEAEmerald@austintx.net>
> > > > > On the "Time On" tab on Services, what's supposed to be in the
> >"Terminate"
> > > > > and the "Connect" columns. There is never anything in these columns on
> >my
> > > > > system.
> > > >
> > > >The Terminate one displays the verbal disconnect cause that's associated
> > > >with the integer values stored in Calls.AcctTerminateCause. If you're
> >using
> > > >Ascend Maxes, you won't see anything in there because Ascend uses
> > > >AscendDisconnectCause and the integer values are completely different
> >from
> > > >the AcctTerminateCause values that come from many other NASes.
> > > >See ftp://ftp.isi.edu/in-notes/rfc2139.txt for the details on this one.
> > > >
> > > >Connect refers to Calls.ConnectInfo. Some NASes use this; some don't--it
> > > >would contain connection speeds and maybe other stuff. Ascend doesn't
> >use
> > > >this one either. It has its own attributes:
> > > > AscendDataRate (user upload speed)
> > > > AscendXmitRate (user download speed)
> > > > Ascend-Modem-PortNo
> > > > Ascend-Modem-SlotNo
> > > >
> > > >Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart