[asterisk-users] CDR: MySQL query

[RSCL Mumbai]

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