On 11/09/09 10:27 AM, Ivan Stepaniuk wrote: > B.Masoud @ SH wrote: >> >> ASR: Average Success Rate >> >> ACD: Average Call duration >> > Simply having your CDR on an SQL database would do the trick. For > example, you can create a query that averages the value of your duration > column. > > Anyway, there are many applications that can be used to analyze your CDR > and even make charts on that. Google for: asterisk cdr analyzer.
Yep, we just use the cdr records. ASR: select disposition, count(*) from cdr group by disposition You'll get: ANSWERED, 200 BUSY, 100 etc Add up all the answered, divide by all the non answered (including congestion etc) and multiply by 100 - that's ASR ACD: select sum(billsecs), count(*) from cdr where disposition = "ANSWERED" sum(billsecs) is the total seconds, count(*) is the total records divide sum(billsecs) by count(*), multiply by 100 - that's ACD -- Cheers, Matt Riddell Director _______________________________________________ http://www.venturevoip.com/news.php (Daily Asterisk News) http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer) http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems) _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
