[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