[Serusers] serweb accounting for cisco ata 186

I am running ser 0.8.12 and serweb_2004-01-04/ Serweb accounting works fine for xten softphones, but ciscos atas records are not shown. Any ideas on how to modify the serweb select query to show them ? The difference seems to be the aditional ";user=phone" on the sip_from, sip_to, and to_uri fields for atas example acc table record for cisco ata 186 <sip:8840@voip.brujula.net;user=phone>;tag=2306858... <sip:00541148029550@voip.brujula.net;user=phone> 200 ACK sip:00541148029550@200.68.120.81 sip:00541148029550@217.199.177.150 sip:8840@voip.brujula.net;user=phone sip:00541148029550@voip.brujula.net;user=phone 146901752(a)200.126.199.228 8840 voip.brujula.net 2306858569 n/a 2004-08-21 19:14:48 20040821161448 serweb accounting.php $q="select t1.to_uri, t1.sip_to, t1.sip_callid, t1.time, ". "t1.fromtag as invft, t2.fromtag as byeft, t2.totag as byett, ". "sec_to_time(unix_timestamp(t2.time)-unix_timestamp(t1.time)) ". "as length, ". "unix_timestamp(t2.time)-unix_timestamp(t1.time) ". "as seconds ". "from ".$config->table_accounting." t1, ". $config->table_accounting." t2 ". "where t1.username='".$auth->auth["uname"]."' and ". "t1.domain='".$config->realm."' and ". "t1.sip_callid=t2.sip_callid and ". "t1.sip_method='INVITE' and t2.sip_method='BYE' ". "order by t1.time desc"; $mc_res=mySQL_query($q); Thanks for the info Jaime Garcia http://voip.brujula.net