ADMINISTRATION: DETAIL ADMIN CHANGE LOG Dashboard - Analytics | Sneat - Bootstrap 5 HTML Admin Template - Pro

ADMIN CHANGE LOG: Record Detail - 1756

ID: 1756
DATE TIME: 2026-08-31 10:58:30
USER: 3112 - 3112
IP: 192.168.29.164
SECTION: LEADS
TYPE: EXPORT
RECORD ID:
DESCRIPTION: ADMIN EXPORT LEADS REPORT
ADMIN GROUP: ---ALL---
NOTES:
SQL:

UPDATE vicidial_report_log set run_time='0.039435' where report_log_id='11144'
SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-31 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') and (vl.user_group IN('ADMIN' ,'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000


DIFF TO LAST CHANGE
ID: 1614          DATE TIME: 2026-08-21 12:05:22          USER: 6666
UPDATE vicidial_report_log set run_time='0.052432' where report_log_id='8208'|SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-07-26 00:00:00' and vl.call_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' UPDATE vicidial_report_log set run_time='0.039435' where report_log_id='11144'|SELECT vl.call_date,vl.phone_number,vi.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,UNIX_TIMESTAMP(vl.call_date),vl.status from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-31 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' '998''999''1001''1111''51099''17072026'
'123456789') and vl.campaign_id IN('16071''AGENTDIRECT''AGENTDIRECT_CHAT') and (vl.user_group IN('ADMIN' '123456789') and vl.campaign_id IN('16071') and (vl.user_group IN('ADMIN'
'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000| 'test') or vl.user_group is null) and vi.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 vl.call_date desc limit 500000|