ok.. I do some testing about new sql... and with your unlang if idea.. could be <div><br></div><div>thanxs to all</div><div><br><br><div class="gmail_quote">2012/9/27 alan buxey <span dir="ltr">&lt;<a href="mailto:A.L.M.Buxey@lboro.ac.uk" target="_blank">A.L.M.Buxey@lboro.ac.uk</a>&gt;</span><br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<div class="im"><br>
&gt;                    key = User-Name    &lt;---- use the if { your patch} ???<br>
<br>
</div>either change this to Stripped-User-Name instead....or if you ONLY want this to<br>
be the full realm when its NOT the realm of interest, then create a new SQL query<br>
and then wrap unlang around it eg<br>
<br>
if (&quot;%{User-Name}&quot; =~ /\@realm.you.want$/i ){<br>
        monthlycounter1<br>
        }<br>
else {<br>
        monthlycounter2<br>
}<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
alan<br>
</font></span><div class="HOEnZb"><div class="h5">-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><font color="#888888"><font color="#888888">Antonio Pe</font><span><font color="#888888">ñ</font></span><font color="#888888">a</font><span></span><br>

<font color="#888888">Secure email with PGP 0x8B021001 available at <a href="http://pgp.mit.edu" target="_blank">http://pgp.mit.edu</a><br></font></font><font color="#888888">
<font color="#888888">Fingerprint: 74E6 2974 B090 366D CE71  7BB2 6476 FA09 8B02 1001</font></font><br>
</div>