Posted:
Mon May 19, 2008 10:36 am
by nekder
something like this??
this is the log for today...
this is what you mean with chopped off?
i hope this can help...
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----CI01_I
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- accountcode =
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callerid = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- calleridname = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callington = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- channel = SIP/agente01-0985aeb8
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- context = default
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- dnid = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- extension = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- language = en
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- priority = 4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- type = SIP
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1211205746.4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|AGI Variables: |1211205746.4|SIP/agente01-0985aeb8|8000|SIP|Closer|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |INBOUNDCI|Closer-8000|2008-05-19 10:02:27
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |01|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list insert |126|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2008-05-19 10:02:27','20080519100227','INBND','8000','8000','VDCL','999','Y','1','01','INBOUNDCI','1','-5.00','agente01');|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|126|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|callerID changed: Y0519100227000000126
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('192.168.0.14','INBOUNDCI','LIVE','126','1211205746.4','Y0519100227000000126','SIP/agente01-0985aeb8','1','01','2008-05-19 10:02:27','IN','LIVE-0')|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('126','INBOUNDCI','2008-05-19 10:02:27','1211205747','QUEUE','1','01','VDCL','N')|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDCL : |126|insert to vicidial_closer_log
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|3|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|CHANNEL SIP/agente01-0985aeb8 DOWN 0 360|4 CHECKING AGAIN
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|4|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|6|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|7|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|8|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|9|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|10|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|11|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|12|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|13|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|14|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|15|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|16|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|17|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|18|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|19|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|20|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|21|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|22|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|23|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|24|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|26|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|27|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|28|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|29|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|30|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|31|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|32|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|33|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|34|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|35|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|36|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|37|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|38|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|39|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|40|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|41|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|42|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|43|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|44|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|45|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|46|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|47|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|48|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|49|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|50|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|51|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|52|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|53|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|54|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|55|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|56|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|57|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|58|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|59|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----CI01_I
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- accountcode =
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callerid = agente01
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- calleridname = agente01
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callington = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- channel = SIP/agente01-0985aeb8
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- context = default
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- dnid = 8000
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- extension = 8000
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- language = en
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- priority = 4
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- type = SIP
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1211205821.5
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|AGI Variables: |1211205821.5|SIP/agente01-0985aeb8|8000|SIP|Closer|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |INBOUNDCI|Closer-8000|2008-05-19 10:03:43
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |01|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list found |126|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|126|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|callerID changed: Y0519100343000000126
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('192.168.0.14','INBOUNDCI','LIVE','126','1211205821.5','Y0519100343000000126','SIP/agente01-0985aeb8','1','01','2008-05-19 10:03:43','IN','LIVE-0')|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('126','INBOUNDCI','2008-05-19 10:03:43','1211205823','QUEUE','1','01','VDCL','N')|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDCL : |126|insert to vicidial_closer_log
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_cal