[asterisk-users] Who said asterisk is not to the task

research at businesstz.com research at businesstz.com
Sat Sep 29 03:49:04 CDT 2012


[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



More information about the asterisk-users mailing list