Login/Logout 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_log 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_log 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_campaigns columns: campaign_id, campaign_name, active, dial_status_a, dial_status_b, dial_status_c, dial_status_d, dial_status_e, lead_order, park_ext, park_file_name, web_form_address, allow_closers, hopper_level, auto_dial_level, next_agent_call, local_call_time, voicemail_ext, dial_timeout, dial_prefix, campaign_cid, campaign_vdad_exten, campaign_rec_exten, campaign_recording, campaign_rec_filename, campaign_script, get_call_launch, am_message_exten, amd_send_to_vmx, xferconf_a_dtmf, xferconf_a_number, xferconf_b_dtmf, xferconf_b_number, alt_number_dialing, scheduled_callbacks, lead_filter_id, drop_call_seconds, drop_action, safe_harbor_exten, display_dialable_count, wrapup_seconds, wrapup_message, closer_campaigns, use_internal_dnc, allcalls_delay, omit_phone_code, dial_method, available_only_ratio_tally, adaptive_dropped_percentage, adaptive_maximum_level, adaptive_latest_server_time, adaptive_intensity, adaptive_dl_diff_target, concurrent_transfers, auto_alt_dial, auto_alt_dial_statuses, agent_pause_codes_active, campaign_description, campaign_changedate, campaign_stats_refresh, campaign_logindate, dial_statuses, disable_alter_custdata, no_hopper_leads_logins, list_order_mix, campaign_allow_inbound, manual_dial_list_id, default_xfer_group, xfer_groups, queue_priority, drop_inbound_group, qc_enabled, qc_statuses, qc_lists, qc_shift_id, qc_get_record_launch, qc_show_recording, qc_web_form_address, qc_script, survey_first_audio_file, survey_dtmf_digits, survey_ni_digit, survey_opt_in_audio_file, survey_ni_audio_file, survey_method, survey_no_response_action, survey_ni_status, survey_response_digit_map, survey_xfer_exten, survey_camp_record_dir, disable_alter_custphone, display_queue_count, manual_dial_filter, agent_clipboard_copy, agent_extended_alt_dial, use_campaign_dnc, three_way_call_cid, three_way_dial_prefix, web_form_target, vtiger_search_category, vtiger_create_call_record, vtiger_create_lead_record, vtiger_screen_login, cpd_amd_action, agent_allow_group_alias, default_group_alias, vtiger_search_dead, vtiger_status_call, survey_third_digit, survey_third_audio_file, survey_third_status, survey_third_exten, survey_fourth_digit, survey_fourth_audio_file, survey_fourth_status, survey_fourth_exten, drop_lockout_time, quick_transfer_button, prepopulate_transfer_preset, drop_rate_group, view_calls_in_queue, view_calls_in_queue_launch, grab_calls_in_queue, call_requeue_button, pause_after_each_call, no_hopper_dialing, agent_dial_owner_only, agent_display_dialable_leads, web_form_address_two, waitforsilence_options, agent_select_territories, campaign_calldate, crm_popup_login, crm_login_address, timer_action, timer_action_message, timer_action_seconds, start_call_url, dispo_call_url, xferconf_c_number, xferconf_d_number, xferconf_e_number, use_custom_cid, scheduled_callbacks_alert, queuemetrics_callstatus_override, extension_appended_cidname, scheduled_callbacks_count, manual_dial_override, blind_monitor_warning, blind_monitor_message, blind_monitor_filename, inbound_queue_no_dial, timer_action_destination, enable_xfer_presets, hide_xfer_number_to_dial, manual_dial_prefix, customer_3way_hangup_logging, customer_3way_hangup_seconds, customer_3way_hangup_action, ivr_park_call, ivr_park_call_agi, manual_preview_dial, realtime_agent_time_stats, use_auto_hopper, auto_hopper_multi, auto_hopper_level, auto_trim_hopper, api_manual_dial, manual_dial_call_time_check, display_leads_count, lead_order_randomize, lead_order_secondary, per_call_notes, my_callback_option, agent_lead_search, agent_lead_search_method, queuemetrics_phone_environment, auto_pause_precall, auto_pause_precall_code, auto_resume_precall, manual_dial_cid, post_phone_time_diff_alert, custom_3way_button_transfer, available_only_tally_threshold, available_only_tally_threshold_agents, dial_level_threshold, dial_level_threshold_agents, safe_harbor_audio, safe_harbor_menu_id, survey_menu_id, callback_days_limit, dl_diff_target_method, disable_dispo_screen, disable_dispo_status, screen_labels, status_display_fields, na_call_url, survey_recording, pllb_grouping, pllb_grouping_limit, call_count_limit, call_count_target, callback_hours_block, callback_list_calltime, user_group, hopper_vlc_dup_check, in_group_dial, in_group_dial_select, safe_harbor_audio_field, pause_after_next_call, owner_populate, use_other_campaign_dnc, allow_emails, amd_inbound_group, amd_callmenu, survey_wait_sec, manual_dial_lead_id, dead_max, dead_max_dispo, dispo_max, dispo_max_dispo, pause_max, max_inbound_calls, manual_dial_search_checkbox, hide_call_log_info, timer_alt_seconds, wrapup_bypass, wrapup_after_hotkey, callback_active_limit, callback_active_limit_override, allow_chats, comments_all_tabs, comments_dispo_screen, comments_callback_screen, qc_comment_history, show_previous_callback, clear_script, cpd_unknown_action, manual_dial_search_filter, web_form_address_three, manual_dial_override_field, status_display_ingroup, customer_gone_seconds, agent_display_fields, am_message_wildcards, manual_dial_timeout, routing_initiated_recordings, manual_dial_hopper_check, callback_useronly_move_minutes, ofcom_uk_drop_calc, manual_auto_next, manual_auto_show, allow_required_fields, dead_to_dispo, agent_xfer_validation, ready_max_logout, callback_display_days, three_way_record_stop, hangup_xfer_record_start, scheduled_callbacks_email_alert, max_inbound_calls_outcome, manual_auto_next_options, agent_screen_time_display, next_dial_my_callbacks, inbound_no_agents_no_dial_container, inbound_no_agents_no_dial_threshold, cid_group_id, pause_max_dispo, script_top_dispo, dead_trigger_seconds, dead_trigger_action, dead_trigger_repeat, dead_trigger_filename, dead_trigger_url, scheduled_callbacks_force_dial, scheduled_callbacks_auto_reschedule, scheduled_callbacks_timezones_container, three_way_volume_buttons, callback_dnc, manual_dial_validation, mute_recordings, auto_active_list_new, call_quota_lead_ranking, call_quota_process_running, call_quota_last_run_date, sip_event_logging, campaign_script_two, leave_vm_no_dispo, leave_vm_message_group_id, dial_timeout_lead_container, amd_type, vmm_daily_limit, opensips_cid_name, amd_agent_route_options, browser_alert_sound, browser_alert_volume, three_way_record_stop_exception, pause_max_exceptions, hopper_drop_run_trigger, daily_call_count_limit, daily_limit_manual, transfer_button_launch, shared_dial_rank, agent_search_method, qc_scorecard_id, qc_statuses_id, clear_form, leave_3way_start_recording, leave_3way_start_recording_exception, calls_waiting_vl_one, calls_waiting_vl_two, calls_inqueue_count_one, calls_inqueue_count_two, in_man_dial_next_ready_seconds, in_man_dial_next_ready_seconds_override, transfer_no_dispo, call_limit_24hour_method, call_limit_24hour_scope, call_limit_24hour, call_limit_24hour_override, cid_group_id_two, incall_tally_threshold_seconds, auto_alt_threshold, pause_max_url, agent_hide_hangup, ig_xfer_list_sort, script_tab_frame_size, max_logged_in_agents, user_group_script, agent_hangup_route, agent_hangup_value, agent_hangup_ig_override, show_confetti, demographic_quotas, demographic_quotas_container, demographic_quotas_rerank, demographic_quotas_last_rerank, demographic_quotas_list_resets, custom_one, custom_two, custom_three, custom_four, custom_five, dead_stop_recording, manual_vm_status_updates, force_per_call_notes, agent_search_ingroup_list, hopper_hold_inserts, daily_phone_number_call_limit, state_descriptions, script_tab_height, call_log_days, leave_3way_stop_recording, manual_minimum_ring_seconds, manual_minimum_attempt_seconds, manual_minimum_answer_seconds, stereo_recording, khomp_settings_container, stereo_rec_filename, stereo_parallel_recording, parallel_rec_co_filename, parallel_rec_cm_filename, parallel_rec_fr_filename, recording_dtmf_muting, stereo_recording_agent, call_count_limit_restrict, adaptive_percentmax_percentage
vicidial_campaigns records: 7
Available columns in vicidial_user_log:
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
Main Query Debug:
SELECT
vul.user AS agent_id,
COALESCE(vu.full_name, vul.user) AS agent_name,
DATE(vul.event_date) AS login_date,
MIN(CASE WHEN vul.event = 'LOGIN' THEN vul.event_date END) AS first_login,
MAX(CASE WHEN vul.event = 'LOGOUT' THEN vul.event_date END) AS last_logout,
COUNT(CASE WHEN vul.event = 'LOGIN' THEN 1 END) AS login_count,
COUNT(CASE WHEN vul.event = 'LOGOUT' THEN 1 END) AS logout_count,
vul.campaign_id,
TIMESTAMPDIFF(SECOND,
MIN(CASE WHEN vul.event = 'LOGIN' THEN vul.event_date END),
MAX(CASE WHEN vul.event = 'LOGOUT' THEN vul.event_date END)
) AS session_duration
FROM vicidial_user_log vul
LEFT JOIN vicidial_users vu ON vul.user = vu.user
WHERE DATE(vul.event_date) BETWEEN ? AND ?
GROUP BY vul.user, DATE(vul.event_date), vul.campaign_id
ORDER BY login_date DESC, agent_name
Parameters: 2026-06-14, 2026-07-14
Data Results:
Login/Logout Records Found: 0
Talk Time Records Found: 0
Pause Records Found: 0
Agent Login/Logout Report
0
Active Agents
0
Total Sessions
00:00:00
Avg Session Time
0
Pause Events
Try expanding the date range or removing filters.