<div class="gmail_extra">Hi,</div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Apr 25, 2012 at 4:44 AM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On 04/25/2012 01:34 PM, Skyler wrote:<br>
> Hrmmm, there was a dev tester yesterday verifying the setup ... maybe<br>
> they clicked on click2dial via CSC.<br>
<br>
</div>Could you show me<br>
select * from acc where src_leg like "%||133%"\G<br>
?<br>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">mysql> select * from acc where src_leg like "%||133%"\G;</div><div class="gmail_extra">*************************** 1. row ***************************</div>
<div class="gmail_extra"> id: 129</div><div class="gmail_extra"> method: INVITE</div><div class="gmail_extra"> from_tag: 5F808EAC-4F9712020003249B-15116700</div><div class="gmail_extra"> to_tag: 18AED02F-4F971202000333DD-13C01700</div>
<div class="gmail_extra"> callid: 700B2758-4F971202000324A4-15116700</div><div class="gmail_extra"> sip_code: 200</div><div class="gmail_extra">sip_reason: OK</div><div class="gmail_extra"> time: 2012-04-24 13:50:14</div>
<div class="gmail_extra">time_hires: 1335300614.920</div><div class="gmail_extra"> src_leg: 1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|<a href="http://sip.mydomain.com">sip.mydomain.com</a>|14574176498||1605|3|||0||1335300610.209136</div>
<div class="gmail_extra"> dst_leg: |1605|3|14574176498|1ceb0639-329d-412a-828f-4ca1f1147c19|14574176498|<a href="http://sip.mydomain.com">sip.mydomain.com</a>|14574176498|<a href="http://sip.mydomain.com">sip.mydomain.com</a></div>
<div class="gmail_extra"> dst_user: 14574176498</div><div class="gmail_extra"> dst_ouser: +13564176492</div><div class="gmail_extra">dst_domain: 25.116.109.202</div><div class="gmail_extra"> src_user: </div><div class="gmail_extra">
src_domain: <a href="http://sip.mydomain.com">sip.mydomain.com</a></div><div class="gmail_extra">*************************** 2. row ***************************</div><div class="gmail_extra"> id: 130</div><div class="gmail_extra">
method: INVITE</div><div class="gmail_extra"> from_tag: 753CF869-4F9712080004EA9E-14A0F700</div><div class="gmail_extra"> to_tag: </div><div class="gmail_extra"> callid: 66E2CDF9-4F9712080004EAA1-14A0F700</div>
<div class="gmail_extra"> sip_code: 404</div><div class="gmail_extra">sip_reason: </div><div class="gmail_extra"> time: 2012-04-24 13:50:16</div><div class="gmail_extra">time_hires: 1335300616.320</div><div class="gmail_extra">
src_leg: 1ceb0639-329d-412a-828f-4ca1f1147c19|16044173292|<a href="http://sip.mydomain.com">sip.mydomain.com</a>|14574176498||1605|3|||0||1335300616.324150</div><div class="gmail_extra"> dst_leg: ||0|+13564176492|0|+13564176492|<a href="http://sip.mydomain.com">sip.mydomain.com</a>|+13564176492|<a href="http://sip.mydomain.com">sip.mydomain.com</a></div>
<div class="gmail_extra"> dst_user: +13564176492</div><div class="gmail_extra"> dst_ouser: +13564176492</div><div class="gmail_extra">dst_domain: <a href="http://sip.mydomain.com">sip.mydomain.com</a></div><div class="gmail_extra">
src_user: </div><div class="gmail_extra">src_domain: <a href="http://sip.mydomain.com">sip.mydomain.com</a></div><div class="gmail_extra">2 rows in set (0.00 sec)</div></div>