Login/Logout Report

Debug Information:

Date Range: 2026-02-13 to 2026-03-15

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: 8,131

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: 2,132,030

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

vicidial_users records: 179

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

vicidial_campaigns records: 4

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

Data Results:

Login/Logout Records Found: 511

Talk Time Records Found: 519

Pause Records Found: 0

Sample Login Data:

Array
(
    [0] => Array
        (
            [agent_id] => 60016
            [agent_name] => 60016
            [login_date] => 2026-03-10
            [first_login] => 2026-03-10 08:13:21
            [last_logout] => 2026-03-10 08:32:23
            [login_count] => 1
            [logout_count] => 1
            [campaign_id] => 2000
            [session_duration] => 1142
        )

    [1] => Array
        (
            [agent_id] => 8010
            [agent_name] => 8010
            [login_date] => 2026-03-10
            [first_login] => 2026-03-10 06:57:34
            [last_logout] => 2026-03-10 10:18:31
            [login_count] => 3
            [logout_count] => 3
            [campaign_id] => 2000
            [session_duration] => 12057
        )

)