ID1613
DATE TIME2026-08-21 11:53:35
USER6666 - Admin
IP192.168.29.223
SECTIONLEADS
TYPEEXPORT
RECORD ID
DESCRIPTIONADMIN EXPORT CALLS REPORT
ADMIN GROUP---ALL---
NOTES
SQLUPDATE vicidial_report_log set run_time='0.005799' where report_log_id='8167'
SELECT vl.call_date,vl.phone_number,vl.status,vl.user,vu.full_name,vl.campaign_id,vi.vendor_lead_code,vi.source_id,vi.list_id,vi.gmt_offset_now,vi.phone_code,vi.phone_number,vi.title,vi.first_name,vi.middle_initial,vi.last_name,vi.address1,vi.address2,vi.address3,vi.city,vi.state,vi.province,vi.postal_code,vi.country_code,vi.gender,vi.date_of_birth,vi.alt_phone,vi.email,vi.security_phrase,vi.comments,vl.length_in_sec,vl.user_group,vl.queue_seconds,vi.rank,vi.owner,vi.lead_id,vl.closecallid,vi.entry_list_id,vl.uniqueid,val.campaign_id, ifnull(val.dispo_sec+val.dead_sec,0),entry_date,vl.called_count,last_local_call_time,modify_date,called_since_last_reset from vicidial_users vu,vicidial_list vi,vicidial_closer_log vl LEFT OUTER JOIN vicidial_agent_log val ON vl.uniqueid=val.uniqueid and vl.lead_id=val.lead_id and vl.user=val.user where vi.entry_date >= '2026-07-26 00:00:00' and vi.entry_date <= '2026-08-21 23:59:59' and vu.user=vl.user and vi.lead_id=vl.lead_id and vl.list_id IN('510' ,'998' ,'999' ,'1001' ,'1111' ,'51099' ,'17072026' ,'123456789') and vl.campaign_id IN('16071' ,'AGENTDIRECT' ,'AGENTDIRECT_CHAT' ,'REMOTEINBOUND' ,'testalex') and vl.user='1607' and (vl.user_group IN('ADMIN' ,'test') or vl.user_group is null) and vl.status IN('A' ,'AA' ,'AB' ,'ADAIR' ,'ADC' ,'ADCT' ,'AFAX' ,'AFTHRS' ,'AL' ,'AM' ,'B' ,'CALLBK' ,'CBHOLD' ,'DAIR' ,'DC' ,'DEC' ,'DNC' ,'DNCC' ,'DNCL' ,'DROP' ,'ERI' ,'INCALL' ,'IQNANQ' ,'IVRXFR' ,'LRERR' ,'LSMERG' ,'MAXCAL' ,'MLINAT' ,'N' ,'NA' ,'NANQUE' ,'NEW' ,'NI' ,'NP' ,'PDROP' ,'PM' ,'PU' ,'QCFAIL' ,'QUEUE' ,'QVMAIL' ,'RQXFER' ,'SALE' ,'SVYCLM' ,'SVYEXT' ,'SVYHU' ,'SVYREC' ,'SVYVM' ,'TIMEOT' ,'XDROP' ,'CB2') order by vi.entry_date asc limit 1000000
DIFF TO LAST CHANGE
ID:1610          DATE TIME: 2026-08-20 17:31:56    USER: 6666
UPDATE vicidial_report_log set run_time='0.014695' where report_log_id='7635'|| UPDATE vicidial_report_log set run_time='0.005799' where report_log_id='8167'|SELECT vl.call_date,vl.phone_number,vl.status,vl.user,vu.full_name,vl.campaign_id,vi.vendor_lead_code,vi.source_id,vi.list_id,vi.gmt_offset_now,vi.phone_code,vi.phone_number,vi.title,vi.first_name,vi.middle_initial,vi.last_name,vi.address1,vi.address2,vi.address3,vi.city,vi.state,vi.province,vi.postal_code,vi.country_code,vi.gender,vi.date_of_birth,vi.alt_phone,vi.email,vi.security_phrase,vi.comments,vl.length_in_sec,vl.user_group,vl.queue_seconds,vi.rank,vi.owner,vi.lead_id,vl.closecallid,vi.entry_list_id,vl.uniqueid,val.campaign_id, ifnull(val.dispo_sec+val.dead_sec,0),entry_date,vl.called_count,last_local_call_time,modify_date,called_since_last_reset from vicidial_users vu,vicidial_list vi,vicidial_closer_log vl LEFT OUTER JOIN vicidial_agent_log val ON vl.uniqueid=val.uniqueid and vl.lead_id=val.lead_id and vl.user=val.user where vi.entry_date >= '2026-07-26 00:00:00' and vi.entry_date <= '2026-08-21 23:59:59' and vu.user=vl.user and vi.lead_id=vl.lead_id and vl.list_id IN('510''998''999''1001''1111''51099''17072026''123456789') and vl.campaign_id IN('16071''AGENTDIRECT''AGENTDIRECT_CHAT''REMOTEINBOUND''testalex') and vl.user='1607' and (vl.user_group IN('ADMIN''test') or vl.user_group is null) and vl.status IN('A''AA''AB''ADAIR''ADC''ADCT''AFAX''AFTHRS''AL''AM''B''CALLBK''CBHOLD''DAIR''DC''DEC''DNC''DNCC''DNCL''DROP''ERI''INCALL''IQNANQ''IVRXFR''LRERR''LSMERG''MAXCAL''MLINAT''N''NA''NANQUE''NEW''NI''NP''PDROP''PM''PU''QCFAIL''QUEUE''QVMAIL''RQXFER''SALE''SVYCLM''SVYEXT''SVYHU''SVYREC''SVYVM''TIMEOT''XDROP''CB2') order by vi.entry_date asc limit 1000000|