Hi,
In CDR table I see some strange numbers:
billing=> select src, disposition, count(*), sum(billsec) from
transfer_voip where substring(src, '^[0-9]*$') is null group by 1, 2
order by 3 desc;
src | disposition | count | sum
-----------+-------------+-------+-------
anonymous | ANSWERED | 329 | 23183
+00 | ANSWERED | 233 | 39802
+00 | NO ANSWER | 40 | 0
anonymous | NO ANSWER | 35 | 0
+0 | ANSWERED | 33 | 2645
C | ANSWERED | 8 | 476
+0 | NO ANSWER | 5 | 0
C | NO ANSWER | 1 | 0
(8 rows)
Who is anonymous, +0, +00 and C?
--
Thanks,
Eugene Prokopiev
_______________________________________________
Callweaver-users mailing list
[email protected]
http://lists.callweaver.org/mailman/listinfo/callweaver-users
