[asterisk-users] queue log vs. cdr

Vieri rentorbuy at yahoo.com
Thu Mar 13 09:17:14 CDT 2008


Hi,

Surely, I must be overlooking something. If I run the
following SQL queries I don't get the same number of
rows. Is this coherent?

mysql> select * from queue_log where queuename =
'4010' and FROM_UNIXTIME(time) between 20080308000000
and 20080313145900 group by callid;

357 rows in set (0.01 sec)

mysql> select * from cdr where dst = 4010 and calldate
between 20080308000000 and 20080313145900 group by
uniqueid;

219 rows in set (0.19 sec)

Thanks!



      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping



More information about the asterisk-users mailing list