On Thursday 04 May 2006 18:04, Colin Anderson wrote: > SELECT count( calldate ) > FROM `cdr` > WHERE calldate > BETWEEN '2006-01-01 00:00:01' AND '2006-05-04 15:51:00' AND channel > LIKE '%IAX2%' AND duration < 1 OR calldate > BETWEEN '2006-01-01 00:00:01' AND '2006-05-04 15:51:00' AND dstchannel > LIKE '%IAX2%' AND duration < 1 > > count(calldate): > 100
That is not a good metric for call completion. Shitty quality will not be counted in that metric... but otherwise, yes. wow. :-) -A. _______________________________________________ --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
