Re: [Emerald] Emerald tables..

Josh Hillman ( (no email) )
Fri, 21 May 1999 15:49:49 -0400

From: talon <talon@virtualight.net>
>I want to query the database, and find which users have static ips.
>What table should I query in sql??

select Name=(firstname+' '+lastname), Active, Login, IPAddress=data
from subaccounts sa, radconfigs rc
where sa.accountid = rc.accountid
and RadAttributeID = 8
order by data

Josh