[asterisk-users] How to get CDR to show answered calls only

[Damon Estep]

Keep in mind that CDR records show calls sent to VM as answered, so you
also have to look at the lastapp field

 

Disposition=answered and lastapp=voicemail means the call was answered
by voicemail (obviously)

 

If you are doing billing you do not care, because the are both billable,
but if you are creating reports "voicemail" and answered are very
different :-)

 

________________________________

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Vicky
Sent: Monday, November 13, 2006 8:29 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to get CDR to show answered calls only

 

Its pretty easy . If you have mysql records enabled via a patch  just do
sql query

use asteriskcdrdb;
select * from `cdr` where billsec > 0 ( if answered then billsec always
greater than 0 or you cna also use disposition = 'ANSWERED' ) 

On 13/11/06, Olivier <oza-4h07 at myamail.com> wrote:

Why is it awful ?
Regards

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061113/06480074/attachment.htm