Dead Call Report
Last Updated: Sep 12, 2026 09:28:44
Debug Information:
Date Range: 2026-08-13 to 2026-09-12
Selected Campaign: All Campaigns
Selected Agent: All Agents
VICIdial Log Records (60 days): 0
Unique Campaigns: 0
Unique Agents: 0
Zero Duration Calls: 0
Very Short Calls (≤1s): 0
Data Range: to
vicidial_log table found with 18 columns
Available columns: uniqueid, lead_id, list_id, campaign_id, call_date, start_epoch, end_epoch, length_in_sec, status, phone_code, phone_number, user, comments, processed, user_group, term_reason, alt_dial, called_count
vicidial_users table found with 155 columns
vicidial_campaigns table found with 367 columns
vicidial_statuses table found with 16 columns
Using short duration calls (≤1 second) as dead call proxy
This is a fallback method for broad compatibility
Main Query Debug:
SELECT vl.call_date, vl.user as agent_id, vl.campaign_id, vl.phone_number, vl.status, vl.length_in_sec, vl.uniqueid, HOUR(vl.call_date) as call_hour, COALESCE(vu.full_name, vl.user) as agent_name, COALESCE(vc.campaign_name, vl.campaign_id) as campaign_name, vl.lead_id
FROM vicidial_log vl
LEFT JOIN vicidial_users vu ON vl.user = vu.user LEFT JOIN vicidial_campaigns vc ON vl.campaign_id = vc.campaign_id
WHERE DATE(vl.call_date) BETWEEN ? AND ? AND vl.length_in_sec <= 1
ORDER BY vl.call_date DESC
LIMIT 1000
Dead Call Condition: vl.length_in_sec <= 1
Parameters: 2026-08-13, 2026-09-12
Query Results:
Detection Method: short_duration
Dead Calls Found: 0
Total Dead Calls: 0
Agents Affected: 0
Campaigns Affected: 0
Dead Call Report
0
Total Dead Calls
0
Agents Affected
0
Campaigns Affected
0
Days with Dead Calls
Method: short_duration
No dead call data found for the selected criteria.
Try expanding the date range, removing filters, or
Try expanding the date range, removing filters, or