shadowym
2006-Nov-10 10:52 UTC
[asterisk-users] How to get CDR to show answered calls only
Is there anyway to get CDR to show just the answered calls. Not by exporting to a spreadsheet and editing. We have ring groups and queues and CDR shows everything as calls received. Even if it's multiple extensions ringing it shows them as multiple calls received. This seems kind of goofy.
mail-lists
2006-Nov-10 11:02 UTC
[asterisk-users] How to get CDR to show answered calls only
shadowym wrote:> Is there anyway to get CDR to show just the answered calls. Not by > exporting to a spreadsheet and editing. We have ring groups and queues and > CDR shows everything as calls received. Even if it's multiple extensions > ringing it shows them as multiple calls received. This seems kind of goofy. > > _______________________________________________ > --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 > >What I've come to realize is that CDR in asterisk is awful. We're looking at doing our own 'CDR' via the userfield
Why is it awful ? Regards -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061113/45994da8/attachment.htm
Damon Estep
2006-Nov-13 18:28 UTC
[asterisk-users] How to get CDR to show answered calls only
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@lists.digium.com [mailto:asterisk-users-bounces@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@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