Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

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


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
rajkumars at gmail.com
Guest





PostPosted: Fri Apr 11, 2008 12:57 pm    Post subject: [asterisk-users] Correlating queue_logs and cdr for abandone Reply with quote

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
Back to top
tilghman at mail.jeffa...
Guest





PostPosted: Fri Apr 11, 2008 1:24 pm    Post subject: [asterisk-users] Correlating queue_logs and cdr for abandone Reply with quote

On Friday 11 April 2008 12:57:17 Rajkumar S wrote:
Quote:
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.

Quote:
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services