AGENTS PERFORMANCE REPORTS WITH HEADER AND COMPLETE TIME REPORT.

 

Agents performance reports with following header and Imp time report.

DROP AND CREATE ANY TABLE ON VICIDIAL DATABASE.

Backup as DB as DUMP:-

mysqldump -uroot -p asterisk > alldb_20250620.sql

1. First Procedure 

### First login as root on the Asterisk Database:
### Open your MySQL_AST_CREATE_tables.sql from your astguiclient files:

nano /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql    

### Find the table you want to copy the create table script:
### Save it to the notepad.
### Login as root on mysql:

2. Second Procedure

root@hostname:~# mysql -p asterisk

mysql> drop table vicidial_log;

### Copy and paste the commands below;

CREATE TABLE vicidial_log (
uniqueid VARCHAR(20) PRIMARY KEY NOT NULL,
lead_id INT(9) UNSIGNED NOT NULL,
list_id BIGINT(14) UNSIGNED,
campaign_id VARCHAR(8),
call_date DATETIME,
start_epoch INT(10) UNSIGNED,
end_epoch INT(10) UNSIGNED,
length_in_sec INT(10),
status VARCHAR(6),
phone_code VARCHAR(10),
phone_number VARCHAR(18),
user VARCHAR(20),
comments VARCHAR(255),
processed ENUM('Y','N'),
user_group VARCHAR(20),
term_reason  ENUM('CALLER','AGENT','QUEUETIMEOUT','ABANDON','AFTERHOURS','NONE') default 'NONE',
alt_dial VARCHAR(6) default 'NONE',
index (lead_id),
index (call_date)
);

mysql>quit

STICKY AGENT CONFIGURATION ON VICIDIAL FOR BOTH INBOUND AND OUTBOUND

STICKY AGENT CONFIGURATION ON VICIDIAL FOR BOTH INBOUND AND OUTBOUND ANY ONE WANTS TO HELP ON THIS, PLease call us on 9953901891

 

How to – Fix “Unable to lookup ‘SERVER_EXTERNAL_IP'”

This error is the newer SVN versions and technically, won’t cause any issues, however here is the fix for it. Type the following command in your Linux Command Line:

sudo sed -i 's/SERVER_EXTERNAL_IP/0.0.0.0/' /etc/asterisk/pjsip.conf

That’s all there is to it.