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

ADMIN CHANGE LOG: Record Detail - 1725

ID: 1725
DATE TIME: 2026-08-26 18:34:29
USER: 6666 - Admin
IP: 192.168.29.194
SECTION: LEADS
TYPE: EXPORT
RECORD ID:
DESCRIPTION: ADMIN EXPORT CALLS REPORT CARRIER
ADMIN GROUP: ---ALL---
NOTES:
SQL:

UPDATE vicidial_report_log set run_time='0.030453' where report_log_id='10348'
SELECT vl.call_date,vl.phone_number,vl.status,vl.user,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 from vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-26 23:59:59' 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' ,'4854') 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 vl.call_date limit 100000


DIFF TO LAST CHANGE
ID: 1719          DATE TIME: 2026-08-26 17:45:20          USER: 6666
UPDATE vicidial_report_log set run_time='0.037221' where report_log_id='10320'|SELECT vl.call_date,vl.phone_number,vl.status,vl.user,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 from vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-26 23:59:59' and vi.lead_id=vl.lead_id and vl.list_id IN('510' UPDATE vicidial_report_log set run_time='0.030453' where report_log_id='10348'|SELECT vl.call_date,vl.phone_number,vl.status,vl.user,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 from vicidial_closer_log vl,vicidial_list vi where vl.call_date >= '2026-08-01 00:00:00' and vl.call_date <= '2026-08-26 23:59:59' 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' '998''999''1001''1111''51099''17072026''123456789') and vl.campaign_id IN('16071'
'4854''AGENTDIRECT''AGENTDIRECT_CHAT''REMOTEINBOUND''testalex') and (vl.user_group IN('ADMIN' '4854') 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 vl.call_date limit 100000| '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 vl.call_date limit 100000|