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

[Tilghman Lesher]

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