by palani.sivagurunathan » Thu Dec 17, 2015 8:05 am
Hi,
Below the full log details.
2015-12-17 18:32:48|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1450357368.187',channel='SIP/112-0000004e',server_ip='182.75.149.242',caller_id_number='0000000000',caller_id_name='station 112',extension='9940062446',call_date='2015-12-17 18:32:48',did_id='3',did_route='IN_GROUP';|
2015-12-17 18:32:48|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1450357368.187',channel='SIP/112-0000004e',server_ip='182.75.149.242',caller_id_number='0000000000',caller_id_name='station 112',extension='9940062446',call_date='2015-12-17 18:32:48',did_id='3',did_route='IN_GROUP';|
2015-12-17 18:32:48|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1450357368.187', channel='SIP/112-0000004e', channel_group='DID_INBOUND', server_ip='182.75.149.242', type='SIP', extension='9940062446', number_dialed='9940062446', caller_code='0000000000', start_time='2015-12-17 18:32:48', start_epoch='1450357368';|
2015-12-17 18:32:48|agi-DID_route.agi|exiting the DID app, transferring call to 99909*3***DID @ default
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- accountcode = 112
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- callerid = 0000000000
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- calleridname = station 112
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- callington = 0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- channel = SIP/112-0000004e
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- context = default
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- dnid = 9899940062446
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- extension = 99909*3***DID
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- language = en
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- priority = 2
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- threadid = 139634157848320
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- type = SIP
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1450357368.187
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi| -- version = 1.8.23.0
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi|AGI Variables: |1450357368.187|SIP/112-0000004e|99909*3***DID|SIP|0000000000|
2015-12-17 18:32:48|18:32:48|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |TOISTEST|0000000000-9940062446|2015-12-17 18:32:48
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|158|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|callerID changed: "Y2171832480000000158 <0000000000>"
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|SELECT auto_call_id from vicidial_auto_calls where uniqueid='1450357368.187' and server_ip='182.75.149.242';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls SET server_ip='182.75.149.242', campaign_id='TOISTEST', status='LIVE', lead_id='158', uniqueid='1450357368.187', callerid='Y2171832480000000158', channel='SIP/112-0000004e', phone_code='1', phone_number='0000000000', call_time='2015-12-17 18:32:48', call_type='IN', stage='LIVE-0', queue_priority='0' ;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|1|SELECT count(*) from vicidial_auto_calls where status = 'LIVE' and campaign_id='TOISTEST';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET queue_position='1' WHERE auto_call_id='39';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='158', campaign_id='TOISTEST', call_date='2015-12-17 18:32:48', start_epoch='1450357368', status='QUEUE', phone_code='1', phone_number='0000000000', user='VDCL', processed='N', xfercallid='0', uniqueid='1450357368.187', queue_position='1',called_count='1',list_id='0' ;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- VDCL : |158|0|150|insert to vicidial_closer_log
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1450357368.187',server_ip='182.75.149.242',call_date='2015-12-17 18:32:48',lead_id = '158',caller_code='Y2171832480000000158',custom_call_id='';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|DID IVR time logged: 2015-12-17 18:32:48|1450357368|1|UPDATE call_log set end_time='2015-12-17 18:32:48',end_epoch='1450357368',length_in_sec=0,length_in_min=' 0.00',extension='Y2171832480000000158' where uniqueid='1450357368.187'|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|-9|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|-8|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|-7|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|-6|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:53|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|-5|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|-4|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|-3|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|-2|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:54|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|-1|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:55|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|8|0|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:56|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|9|1|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:57|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|10|2|1|0|0||0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:32:58|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20151217183259|Y2171832480000000158||
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|15|0|1|0|0|1|0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20151217183308|Y2171832480000000158|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi||SELECT queue_seconds FROM vicidial_closer_log where campaign_id = 'TOISTEST' and status NOT IN('NANQUE','QUEUE') order by call_date desc limit 5;|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi||SELECT stage FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time <= "2015-12-17 18:32:48";|
2015-12-17 18:32:48|18:33:03|agi-VDAD_ALL_inbound.agi|-- HOLD ESTIMATE: |TOISTEST|0|13|13| |28|0|28|15|
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|16|1|1|0|0|0|0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:04|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|17|2|1|0|0|0|0|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:05|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20151217183306|Y2171832480000000158||
2015-12-17 18:32:48|18:33:10|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record for Wait-Time-Option-Press: |1|20151217183320|Y2171832480000000158||
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|interrupt_digit |0| |to-be-called-back|digits/1|
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|digit |1| TotalDTMF |1|
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|digit || TotalDTMF |1|
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|WAIT TIME OPTION PRESSED 1: CALLERID_CALLBACK|WAITTO
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|-- VDCL WAIT TIME OPT: |CALLERID_CALLBACK|8300|2|
2015-12-17 18:32:48|18:33:14|agi-VDAD_ALL_inbound.agi|-- WAIT OPTION PRIORITY, HOLD NO RUN: |26|WAIT| |1| |Y2171832480000000158|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|27|0|1|0|0|1|1|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20151217183320|Y2171832480000000158|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi||SELECT queue_seconds FROM vicidial_closer_log where campaign_id = 'TOISTEST' and status NOT IN('NANQUE','QUEUE') order by call_date desc limit 5;|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi||SELECT stage FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time <= "2015-12-17 18:32:48";|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|-- HOLD ESTIMATE: |TOISTEST|0|10|10| |28|0|28|27|
2015-12-17 18:32:48|18:33:15|agi-VDAD_ALL_inbound.agi|-- WAIT OPTION PRIORITY, HOLD NO RUN: |30|WAIT| |1| |Y2171832480000000158|
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|28|1|1|0|0|0|1|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:16|agi-VDAD_ALL_inbound.agi|-- WAIT OPTION PRIORITY, HOLD NO RUN: |28|WAIT| |1| |Y2171832480000000158|
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TOISTEST' and call_time < "2015-12-17 18:32:48" and lead_id != '158' and queue_priority >= '0' and agent_only='';|
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '158' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2015-12-17 18:32:48") );|
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('XTURION') and closer_campaigns LIKE "% TOISTEST %" and last_update_time > '20151217183241' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_call_finish limit 1;|
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|29|2|1|0|0|0|1|update of vla table: TOISTEST|
|UNLOCK TABLES;|
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2015-12-17 18:32:48|18:33:17|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20151217183318|Y2171832480000000158||
Thanks,
Palanivel