Rajkumar S
2008-Apr-11 17:57 UTC
[asterisk-users] Correlating queue_logs and cdr for abandoned calls
Hi, I am using asterisk 1.4.19, my requirement is to find out which agents were ringed by the queue when a call is abandoned (or connected) in a call center. While this information is available in parts in queue_logs and cdr, there is no way to correlate this information. For example this is the queue_log entries for a call that was abandoned 1207935049|1207935049.6|queue|NONE|ENTERQUEUE||_0_0000 1207935060|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 1207935078|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 1207935090|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 1207935093|1207935049.6|queue|NONE|ABANDON|1|1|44 and cdr during this time: "","3501","5501","sip","""3501"" <3501>","Local/5501 at sip-2a94,2","SIP/5501-082495a8","Dial","SIP/5501","2008-04-11 17:30:49",,"2008-04-11 17:31:00",11,0,"NO ANSWER","DOCUMENTATION","1207935049.8","" "","3501","5501","sip","""3501"" <3501>","Local/5501 at sip-f107,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008-04-11 17:31:08",,"2008-04-11 17:31:18",10,0,"NO ANSWER","DOCUMENTATION","1207935068.11","" "","3501","5501","sip","""3501"" <3501>","Local/5501 at sip-308c,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008-04-11 17:31:19",,"2008-04-11 17:31:30",11,0,"NO ANSWER","DOCUMENTATION","1207935079.14","" "","3501","5501","sip","""3501"" <3501>","Local/5501 at sip-668b,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008-04-11 17:31:31",,"2008-04-11 17:31:33",2,0,"NO ANSWER","DOCUMENTATION","1207935091.17","" there are no common fields in both logs to correlate them. Also missing in the cdr is the entry for the call coming in. ie record if the call from the customer to the callcenter. This entry is present when the call is completed. Just wondering how others are dealing with this requirement and if missing cdr entry is a bug? regards, raj
Tilghman Lesher
2008-Apr-11 18:24 UTC
[asterisk-users] Correlating queue_logs and cdr for abandoned calls
On Friday 11 April 2008 12:57:17 Rajkumar S wrote:> I am using asterisk 1.4.19, my requirement is to find out which agents > were ringed by the queue when a call is abandoned (or connected) in a > call center. While this information is available in parts in > queue_logs and cdr, there is no way to correlate this information. For > example this is the queue_log entries for a call that was abandoned > > 1207935049|1207935049.6|queue|NONE|ENTERQUEUE||_0_0000 > 1207935060|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 > 1207935078|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 > 1207935090|1207935049.6|queue|Agent/3501|RINGNOANSWER|10000 > 1207935093|1207935049.6|queue|NONE|ABANDON|1|1|44 > > and cdr during this time: > > "","3501","5501","sip","""3501"" > <3501>","Local/5501 at sip-2a94,2","SIP/5501-082495a8","Dial","SIP/5501","2008 >-04-11 17:30:49",,"2008-04-11 17:31:00",11,0,"NO > ANSWER","DOCUMENTATION","1207935049.8","" > "","3501","5501","sip","""3501"" > <3501>","Local/5501 at sip-f107,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008 >-04-11 17:31:08",,"2008-04-11 17:31:18",10,0,"NO > ANSWER","DOCUMENTATION","1207935068.11","" > "","3501","5501","sip","""3501"" > <3501>","Local/5501 at sip-308c,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008 >-04-11 17:31:19",,"2008-04-11 17:31:30",11,0,"NO > ANSWER","DOCUMENTATION","1207935079.14","" > "","3501","5501","sip","""3501"" > <3501>","Local/5501 at sip-668b,2","SIP/5501-0824b5f8","Dial","SIP/5501","2008 >-04-11 17:31:31",,"2008-04-11 17:31:33",2,0,"NO > ANSWER","DOCUMENTATION","1207935091.17","" > > there are no common fields in both logs to correlate them.Actually, there are. Check the second field in the queue log and the second-to-last field in the CDR. This is the uniqueid field, and it's present in both.> Also > missing in the cdr is the entry for the call coming in. ie record if > the call from the customer to the callcenter. This entry is present > when the call is completed. Just wondering how others are dealing with > this requirement and if missing cdr entry is a bug?Check your settings in cdr.conf. Logging unanswered calls is an option available to the PBX administrator. -- Tilghman