[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