Re: SQL Statement

Dale E. Reed Jr. ( (no email) )
Wed, 04 Feb 1998 01:40:53 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Mohammed Ersan: "Re: Invoices & Renewals"
Next message: Jeremy Domingue: "New Portmasters don't work with calls online?"
Maybe in reply to: Wayne Jordan: "SQL Statement"

Wayne Jordan wrote:
>
> 1. I need the SQL statement that gives the time on usage for the current
> month. Similar to the one used in the TimeOn tab under the services.

There is a program that comes with SQL Server caleld SQL Trace. You
can run it against your SQL Server and see all the SQL Statements
that Emerald generates.

> 2. How do you insert the CallerID field in the Calls Table?

Add a field to your calls table named "CalledID", type varchar(8)
(or whatever your field size requirement is) and then restart
RadiusNT. Make sure you have the CallerID attribute in your
RadAttributes table as well.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Mohammed Ersan: "Re: Invoices & Renewals"
Next message: Jeremy Domingue: "New Portmasters don't work with calls online?"
Maybe in reply to: Wayne Jordan: "SQL Statement"