Thx Rudi. but this query results in *Empty set (0.32 sec)
src AND dst like number *seems to be the problem area.
*
*
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).
Thx
Sans
On Wed, Aug 4, 2010 at 6:18 PM, Rudi Oosthuizen
<rudi.oosthuizen at nha.co.za>wrote:
> Mysql
> Use asteriskcdrdb;
> Select calldate,src,dst,disposition,duration,billsec,uniqueid from cdr
> where src like 'NUMBER' and dst like 'NUMBER' order by
calldate;
>
>
> Rudi Oosthuzen
>
>
>
>
>
> > Hi,
>
> > Can someone help me formulate MySQL Query(s) which will help me
> extract the
> > following details for a given DID (date range can be excluded
for
> > simplicity).
>
> > Date-Time
> > DNID (I am recording this is `userfield`)
> > CLID
> > time-1 (when call was received)
> > time-2 (when call was answered by agent)
> > time-3 (when call was hung-up)
>
> > My Call flow is as follows:
> > - Caller dials a DNID
> > - Call enters queue
> > - Call rings in round-robin format to all logged in agents
> > - Agent answers call
> > - Both parties hand-up
>
> > Any help with MySQL queries or pointers are deeply appreciated.
>
> > Thx
> > Sans
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100805/24ffd4d9/attachment.htm