Thx Rudi. but this query results in <b>Empty set (0.32 sec)<br>src AND dst like number </b>seems to be the problem area.<br><b><br></b>
<br>
Also, how can I get the hold time & talk time as separate
values OR may be total call connect time & talk time (the difference
of the 2 will be hold time).<br>
<br>
Thx<br>
Sans<br><br><br><div class="gmail_quote">On Wed, Aug 4, 2010 at 6:18 PM, Rudi Oosthuizen <span dir="ltr"><<a href="mailto:rudi.oosthuizen@nha.co.za">rudi.oosthuizen@nha.co.za</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Mysql<br>
Use asteriskcdrdb;<br>
Select calldate,src,dst,disposition,duration,billsec,uniqueid from cdr where src like 'NUMBER' and dst like 'NUMBER' order by calldate;<br>
<br>
<br>
Rudi Oosthuzen<br>
<br>
<br>
<br>
<br>
<br>
> Hi,<br>
<br>
> Can someone help me formulate MySQL Query(s) which will help me extract the<br>
> following details for a given DID (date range can be excluded for<br>
> simplicity).<br>
<br>
> Date-Time<br>
> DNID (I am recording this is `userfield`)<br>
> CLID<br>
> time-1 (when call was received)<br>
> time-2 (when call was answered by agent)<br>
> time-3 (when call was hung-up)<br>
<br>
> My Call flow is as follows:<br>
> - Caller dials a DNID<br>
> - Call enters queue<br>
> - Call rings in round-robin format to all logged in agents<br>
> - Agent answers call<br>
> - Both parties hand-up<br>
<br>
> Any help with MySQL queries or pointers are deeply appreciated.<br>
<br>
> Thx<br>
> Sans<br>
</blockquote></div><br>