Pause Code Report
Debug Information:
Date Range: 2026-06-14 to 2026-07-14
vicidial_user_log columns: user_log_id, user, event, campaign_id, event_date, event_epoch, user_group, session_id, server_ip, extension, computer_ip, browser, data, phone_login, server_phone, phone_ip, webserver, login_url, browser_width, browser_height
vicidial_user_log records: 0
vicidial_agent_log columns: agent_log_id, user, server_ip, event_time, lead_id, campaign_id, pause_epoch, pause_sec, wait_epoch, wait_sec, talk_epoch, talk_sec, dispo_epoch, dispo_sec, status, user_group, comments, sub_status, dead_epoch, dead_sec, processed, uniqueid, pause_type
vicidial_agent_log records: 0
vicidial_pause_codes columns: pause_code, pause_code_name, billable, campaign_id, time_limit, require_mgr_approval
vicidial_pause_codes records: 0
vicidial_users columns: user_id, user, pass, full_name, user_level, user_group, phone_login, phone_pass, delete_users, delete_user_groups, delete_lists, delete_campaigns, delete_ingroups, delete_remote_agents, load_leads, campaign_detail, ast_admin_access, ast_delete_phones, delete_scripts, modify_leads, hotkeys_active, change_agent_campaign, agent_choose_ingroups, closer_campaigns, scheduled_callbacks, agentonly_callbacks, agentcall_manual, vicidial_recording, vicidial_transfers, delete_filters, alter_agent_interface_options, closer_default_blended, delete_call_times, modify_call_times, modify_users, modify_campaigns, modify_lists, modify_scripts, modify_filters, modify_ingroups, modify_usergroups, modify_remoteagents, modify_servers, view_reports, vicidial_recording_override, alter_custdata_override, qc_enabled, qc_user_level, qc_pass, qc_finish, qc_commit, add_timeclock_log, modify_timeclock_log, delete_timeclock_log, alter_custphone_override, vdc_agent_api_access, modify_inbound_dids, delete_inbound_dids, active, alert_enabled, download_lists, agent_shift_enforcement_override, manager_shift_enforcement_override, shift_override_flag, export_reports, delete_from_dnc, email, user_code, territory, allow_alerts, agent_choose_territories, custom_one, custom_two, custom_three, custom_four, custom_five, voicemail_id, agent_call_log_view_override, callcard_admin, agent_choose_blended, realtime_block_user_info, custom_fields_modify, force_change_password, agent_lead_search_override, modify_shifts, modify_phones, modify_carriers, modify_labels, modify_statuses, modify_voicemail, modify_audiostore, modify_moh, modify_tts, preset_contact_search, modify_contacts, modify_same_user_level, admin_hide_lead_data, admin_hide_phone_data, agentcall_email, modify_email_accounts, failed_login_count, last_login_date, last_ip, pass_hash, alter_admin_interface_options, max_inbound_calls, modify_custom_dialplans, wrapup_seconds_override, modify_languages, selected_language, user_choose_language, ignore_group_on_search, api_list_restrict, api_allowed_functions, lead_filter_id, admin_cf_show_hidden, agentcall_chat, user_hide_realtime, access_recordings, modify_colors, user_nickname, user_new_lead_limit, api_only_user, modify_auto_reports, modify_ip_lists, ignore_ip_list, ready_max_logout, export_gdpr_leads, pause_code_approval, max_hopper_calls, max_hopper_calls_hour, mute_recordings, hide_call_log_info, next_dial_my_callbacks, user_admin_redirect_url, max_inbound_filter_enabled, max_inbound_filter_statuses, max_inbound_filter_ingroups, max_inbound_filter_min_sec, status_group_id, mobile_number, two_factor_override, manual_dial_filter, user_location, download_invalid_files, user_group_two, failed_login_attempts_today, failed_login_count_today, failed_last_ip_today, failed_last_type_today, modify_dial_prefix, inbound_credits, hci_enabled, modify_stamp, manual_dial_lead_id
vicidial_users records: 256
vicidial_user_log columns:
user_log_id, user, event, campaign_id, event_date, event_epoch, user_group, session_id, server_ip, extension, computer_ip, browser, data, phone_login, server_phone, phone_ip, webserver, login_url, browser_width, browser_height
User Log Query Debug:
SELECT
vul.user AS agent_id,
COALESCE(vu.full_name, vul.user) AS agent_name,
COALESCE(vul.pause_code, 'UNKNOWN') AS pause_code,
COALESCE(vpc.pause_code_name, 'Unknown Pause Code') AS pause_code_name,
COUNT(*) AS frequency,
COUNT(*) * 60 AS total_pause_time,
60 AS avg_pause_time,
60 AS min_pause_time,
60 AS max_pause_time,
DATE(vul.event_date) AS pause_date
FROM vicidial_user_log vul
LEFT JOIN vicidial_users vu ON vul.user = vu.user
LEFT JOIN vicidial_pause_codes vpc ON vul.pause_code = vpc.pause_code
WHERE DATE(vul.event_date) BETWEEN ? AND ? AND vul.event LIKE '%PAUSE%'
GROUP BY vul.user, vul.pause_code, DATE(vul.event_date)
ORDER BY pause_date DESC, total_pause_time DESC
Parameters: 2026-06-14, 2026-07-14
vicidial_agent_log columns:
agent_log_id, user, server_ip, event_time, lead_id, campaign_id, pause_epoch, pause_sec, wait_epoch, wait_sec, talk_epoch, talk_sec, dispo_epoch, dispo_sec, status, user_group, comments, sub_status, dead_epoch, dead_sec, processed, uniqueid, pause_type
Agent Log Query Debug:
SELECT
al.user AS agent_id,
COALESCE(vu.full_name, al.user) AS agent_name,
'GENERAL' AS pause_code,
'General Pause' AS pause_code_name,
COUNT(*) AS frequency,
SUM(al.pause_sec) AS total_pause_time,
AVG(al.pause_sec) AS avg_pause_time,
MIN(al.pause_sec) AS min_pause_time,
MAX(al.pause_sec) AS max_pause_time,
DATE(al.event_time) AS pause_date
FROM vicidial_agent_log al
LEFT JOIN vicidial_users vu ON al.user = vu.user
WHERE DATE(al.event_time) BETWEEN ? AND ? AND al.pause_sec > 0
GROUP BY al.user, 'GENERAL', DATE(al.event_time)
ORDER BY pause_date DESC, total_pause_time DESC
Parameters: 2026-06-14, 2026-07-14
Data Results:
Data Source: none
Pause Records Found: 0
Summary Records Found: 0
Agent Summary Records Found: 0
Agent Pause Code Report
0
Agents
0
Total Pauses
00:00:00
Total Pause Time
00:00:00
Avg Pause Duration
Try expanding the date range or removing filters.