ADMIN CHANGE LOG: Record Detail - 1718 ID: 1718 DATE TIME: 2026-08-26 16:40:56 USER: 6666 - Admin IP: 192.168.29.174 SECTION: LEADS TYPE: EXPORT RECORD ID: DESCRIPTION: ADMIN EXPORT CALLS REPORT ADMIN GROUP: ---ALL--- NOTES: SQL: UPDATE vicidial_report_log set run_time='0.017797' where report_log_id='10157' DIFF TO LAST CHANGE ID: 1613          DATE TIME: 2026-08-21 11:53:35          USER: 6666 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| UPDATE vicidial_report_log set run_time='0.017797' where report_log_id='10157'||