Re: SQL Statement

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

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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |