Re: [asterisk-users] queue log vs. cdr
--- Atis Lezdins <[EMAIL PROTECTED]> wrote: > Hmm, didn't knew that queue_log can be written into > MySQL.. Asterisk 1.6 beta has that through realtime. But I'm using a custom import script in earlier Asterisk versions. > Is callid in queue_log the same uniqueid? yes. > You can do > something like this: > > CREATE TEMPORARY TABLE a TYPE=MEMORY select * from > queue_log where > queuename = '4010' and FROM_UNIXTIME(time) between > 2008030800 > and 20080313145900 group by callid; > > CREATE TEMPORARY TABLE b TYPE=MEMORY select * from > cdr where dst = > 4010 and calldate between 2008030800 and > 20080313145900 group by > uniqueid; > > and then compare: > > SELECT * FROM a WHERE callid NOT IN (SELECT uniqueid > FROM b) > SELECT * FROM b WHERE uniqueid NOT IN (SELECT callid > FROM a) Thanks. It seems that the missing records in the cdr table are due to the fact that the dst field isn't 4010 as expected but the extension to which the call was transferred by the agent (dcontext indicates transfer event). Strange so I guess I'll have to review the dialplan closely. 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
Re: [asterisk-users] queue log vs. cdr
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 2008030800 > and 20080313145900 group by callid; > > 357 rows in set (0.01 sec) > > mysql> select * from cdr where dst = 4010 and calldate > between 2008030800 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 > ___ -- 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
Re: [asterisk-users] queue log vs. cdr
On 3/13/08, Vieri <[EMAIL PROTECTED]> 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 2008030800 > and 20080313145900 group by callid; > > 357 rows in set (0.01 sec) > > mysql> select * from cdr where dst = 4010 and calldate > between 2008030800 and 20080313145900 group by > uniqueid; > > 219 rows in set (0.19 sec) > > Thanks! > Hmm, didn't knew that queue_log can be written into MySQL.. that's something useful for me :) Is callid in queue_log the same uniqueid? You can do something like this: CREATE TEMPORARY TABLE a TYPE=MEMORY select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 2008030800 and 20080313145900 group by callid; CREATE TEMPORARY TABLE b TYPE=MEMORY select * from cdr where dst = 4010 and calldate between 2008030800 and 20080313145900 group by uniqueid; and then compare: SELECT * FROM a WHERE callid NOT IN (SELECT uniqueid FROM b) SELECT * FROM b WHERE uniqueid NOT IN (SELECT callid FROM a) Regards, Atis -- Atis Lezdins, VoIP Project Manager / Developer, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 ___ -- 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
[asterisk-users] queue log vs. cdr
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 2008030800 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 2008030800 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