[tz-ivr01 ~]# uptime 11:00:32 up 776 days, 10:49, 3 users, load average: 3.06, 3.05, 2.57 Sharing is caring
[tz-ivr01 ~]# asterisk -rx 'core show channels' |wc -l 213 mysql> select count(*) from cdr where calldate > '2012-01-01 00:00:00' and calldate <'2012-09-29 00:00:00' group by disposition; +----------+ | count(*) | +----------+ | 42926974 | +----------+ 1 row in set (1.63 sec) mysql> select disposition, sum(billsec) from cdr where calldate >'2012-01-01 00:00:00' and calldate <'2012-09-29 00:00:00' group by disposition; +-------------+--------------+ | disposition | sum(billsec) | +-------------+--------------+ | ANSWERED | 4262026740 | +-------------+--------------+ 1 row in set (1.21 sec) Sam -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
