[asterisk-users] Cdr reports

[Atis]

On 8/20/07, Carlos Chavez <cursor at telecomabmex.com> wrote:
> On Mon, 2007-08-20 at 11:45 -0500, Jordan Novak wrote:
> > I am trying to figure out how long a caller waited in queue for
> > someone to answer versus how long they stayed on the phone after the
> > answer. I am assuming that the duration is the total talk time and
> > that the billsecs are the total time in queue. is this correct? or
> > should i be deducting the billsecs from the duration to get this
> > number?
>
>         That information you need to extract from queue_log and not from the
> CDR.  You need something like Queuemetrics to give you comprehensive
> reports on queue and agent activity.

The problem with queue_log is - that it is not stored in mysql :p

For me this works great:

On entering queue, call ResetCDR() - if there are some prompts/IVRs
before.. I think, this also resets answer status, so you will have new
answer status for agent picking up in queue's CDR.

Queue will have one CDR, and each ringed agent will have another (and
some more in 1.4). Then in queue's CDR you will have billsec -
conversation time, and duration - total time while connected to queue.
So - waiting time is billsec-duration.

Regards,
Atis

-- 
Atis Lezdins,
IT Responsible of BEST Riga,
atis at BEST.eu.org
ICQ: 142239285
Skype: atis.lezdins
Cell Phone: +371 28806004 [Tele2, Latvia]
Work phone: +1 800 7502835 [Toll free, USA]
?BEST? -> www.BEST.eu.org