<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>SQL Statement in users file</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Does this seem like a doable scenario in the users file it doesn't return anything but I'm not sure if it is query issue or if those values are not available in the users file.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">DEFAULT Auth-Type = "ntlm_auth"</FONT>
<BR><FONT SIZE=2 FACE="Arial"> Tunnel-Type = "VLAN",</FONT>
<BR><FONT SIZE=2 FACE="Arial"> Tunnel-Medium-Type = "IEEE-802",</FONT>
<BR><FONT SIZE=2 FACE="Arial"> Tunnel-Private-Group-id = "%{sql:SELECT 'vlans.assigned_vlan' FROM 'vlans' WHERE 'vlans.device_mac' = '%{Calling-Station-Id}'}"</FONT></P>
<P><FONT SIZE=2 FACE="Calibri">Joseph R. McSparin<BR>
Network Administrator<BR>
Hill Country Memorial Hospital<BR>
830 990 6638 phone<BR>
830 990 6623 fax<BR>
jmcsparin@hillcountrymemorial.org</FONT>
</P>
</BODY>
</HTML>
<BR><HR>
<p class="MsoNormal"><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"><font size="1"><span style="font-family: tahoma,arial,helvetica,sans-serif;">This email message and any
attachments are for the sole use of the intended recipient(s) and contain
confidential and/or privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient,
please contact the sender by reply email and destroy all copies of the original
message and any attachments.</span></font><o:p /></span></font></p>