RE: [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 J   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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

_______________________________________________
--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