[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