[asterisk-users] queue log vs. cdr
Rob Hillis
rob at hillis.dyndns.org
Thu Mar 13 10:24:10 CDT 2008
Yes it is.
The reason you get more entries in queue_log is that there are several
queue_log events per call - most commonly you get an "ENTERQUEUE",
"CONNECT" and "COMPLETECALLER/AGENT" for each call.
Vieri wrote:
> 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
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
More information about the asterisk-users
mailing list