[asterisk-users] billsec exceeds duration on some calls

[Matt Riddell]

On 21/08/10 5:24 AM, A J Stiles wrote:
> Can anyone else with a similar setup try running a query such as
> SELECT COUNT(*) FROM cdr WHERE calldate LIKE "2010-08-20%" AND
> billsec>duration ;
> and seeing if they have any calls like this?

Nothing on this box (1.4)

mysql> SELECT COUNT(*) FROM cdr WHERE billsec>duration; 

+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.31 sec)

mysql> SELECT COUNT(*) FROM cdr;
+----------+
| COUNT(*) |
+----------+
|   190052 |
+----------+
1 row in set (0.00 sec)

-- 
Cheers,

Matt Riddell
_______________________________________________

http://www.venturevoip.com/news.php (Daily Asterisk News)
http://www.venturevoip.com/exchange.php (Full ITSP Solution)
http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer)