[asterisk-users] Correlating queue_logs and cdr for abandoned calls

[Rajkumar S]

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