Re: [Emerald] Emerald tables..

talon ( (no email) )
Fri, 21 May 1999 14:32:45 EST

I would like a statement where I could just select the ips in the format of 209.100.144.* from data.

Any ideas on how to just pull the 209.100.144.* info from the Data?

- Tim
---------- Original Message ----------------------------------
From: Sheryl Weidner <>
Date: Fri, 21 May 1999 12:21:41 -0700


The RadConfigs table uses the AccountID (from the SubAccounts table) as
a foreign key, and contains the specific values for each user's custom
Radius attributes. I'd use an "if exists" type of statement, since
there will be multiple entries for each AccountID in the RadConfigs
table if they have custom attributes.

The Emerald Administrator's Guide includes a database schema appendix
and contains extensive descriptions for each table and column. In
addition, if you have Visio Professional on a machine where you also
have Emerald installed, you can use it to map the database so you can
see the foreign and primary key information for each table (use the
undirected diagram for best results).

talon wrote:

> I want to query the database, and find which users have static ips.
> What table should I query in sql??
> - Tim

--Sheryl D. Weidner, Customer Support ManagerIEA Software, Inc. // 831-459-9430 (voice) // 831-459-9434 (fax) // 500 Seabright #202 // Santa Cruz, CA