Call Detail Report (CDR)
Last Updated: Sep 12, 2026 09:29:30
Debug Information:
Date Range: 2026-09-05 to 2026-09-12
Selected Campaign: All Campaigns
Selected Agent: All Agents
Selected Disposition: All Dispositions
Phone Number: Not filtered
Page: 1, Records per page: 50
VICIdial Log Records (30 days): 0
Unique Campaigns: 0
Unique Agents: 0
Data Range: to
vicidial_log table found with 18 columns
vicidial_users table found with 155 columns
vicidial_campaigns table found with 367 columns
vicidial_statuses table found with 16 columns
recording_log table found with 15 columns
Recording Log Integration:
Join Column: vicidial_id
Filename Column: filename
Location Column: location
Main CDR Query:
SELECT vl.call_date, vl.user as agent_id, vl.campaign_id, vl.lead_id, vl.phone_number, vl.status as disposition, vl.length_in_sec as duration, vl.uniqueid, COALESCE(u.full_name, vl.user) as agent_name, COALESCE(vc.campaign_name, vl.campaign_id) as campaign_name, COALESCE(vs.status_name, vl.status) as disposition_name, rl.filename as recording_filename, rl.location as recording_location, vl.term_reason, vl.list_id
FROM vicidial_log vl
LEFT JOIN vicidial_users u ON vl.user = u.user LEFT JOIN vicidial_campaigns vc ON vl.campaign_id = vc.campaign_id LEFT JOIN vicidial_statuses vs ON vl.status = vs.status LEFT JOIN recording_log rl ON vl.uniqueid = rl.vicidial_id
WHERE DATE(vl.call_date) BETWEEN ? AND ?
ORDER BY vl.call_date DESC
LIMIT 50 OFFSET 0
Parameters: 2026-09-05, 2026-09-12
Data Source: vicidial_log + users + campaigns + statuses + recordings
Query Results:
CDR Records Found: 0
Total Records: 0
Summary Stats: 0 calls, 0 sales
Call Detail Report (CDR)
0
Total Calls
0
Sales Made
00:00:00
Avg Duration
Data: vicidial_log + users + campaigns + statuses + recordings0
Unique Agents
No call detail records found for the selected criteria.
Try expanding the date range, removing filters, or
Try expanding the date range, removing filters, or