[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_ 1207935060|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935078|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935090|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935093|1207935049.6|queue|NONE|ABANDON|1|1|44 and cdr during this time: ,3501,5501,sip,3501 3501,Local/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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 ___ -- 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] 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_ 1207935060|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935078|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935090|1207935049.6|queue|Agent/3501|RINGNOANSWER|1 1207935093|1207935049.6|queue|NONE|ABANDON|1|1|44 and cdr during this time: ,3501,5501,sip,3501 3501,Local/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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/[EMAIL PROTECTED],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 ___ -- 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