[Asterisk-Users] MySQL CDRs

[Steven Poelmans]

Outbound calls are not logged seperatly in the CDR. So the duration is
the "time the hangup extension ends" minus "time someone dials in on *".

Although I think it could be usefull to seperatly log an outgoing
call-session when it was bridged... My .02 euro.

with kind regards,
Steven

On Wed, 2003-12-31 at 09:48, Ahmad Faiz wrote:
> When using mysql cdrs, are all legs of a call session logged in the cdr
> table? i'm building an app that requires billing on both the incoming and
> outgoing (3rd-party transfers) legs.
> 
> here's a snapshot of my cdr table:
> 
> +---------------------+-----+-----+---------+------------+----------+-------
> --+
> | calldate            | src | dst | channel | dstchannel | duration |
> billsec |
> +---------------------+-----+-----+---------+------------+----------+-------
> --+
> | 2003-12-31 16:19:08 |     | s   | vpb/1-3 | vpb/1-1    |       69 |
> 67 |
> | 2003-12-31 16:20:25 |     | s   | vpb/1-3 | vpb/1-1    |       48 |
> 47 |
> 
> can someone verify if my assumptions below are correct?
> 
> 1) these two records are for two call sessions, where both sessions had an
> inbound and an outbound leg
> 2) the 'duration' column only shows total time for the inbound leg
> 
> if assumption #2 is correct, how would i be able to record the duration when
> the outbound leg is bridged in to the inbound leg?
> 
> faiz
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users