How to delete old call logs leads Datas in vicidial
Vicidial Deleting old Call Logs
 |
| how to delete old calllogs in vicidail |
Overview:
VICIdial is an enterprise class, open source, contact center suite in use by many large call centers around the world. VICIdial has a full featured predictive dialer. It is capable of inbound, outbound, and blended phone call handling.
MySQL is an open-source relational database management system (RDBMS),
MariaDB is a fork of the MySQL database management system.
Vicidial use either mysql or mariadb as there default database software.
Purpose of this Article:
Over the years you might be running the vicidial which will save all the data like users call logs, Leads log, recording links, agent status, Reports etc, which will fill the database and disk space, In that scenario you might want to delete old data or Flush all data in vicidial kind of factory reset the vicidial.
In this blog post i have provide steps to delete old data in vicidial database, you can also use the same commands to flush all date.
I have Video tutorial for the same steps mentioned in this blog, refer below link
Steps To delete or Flush Old data
Step 1: Login to Mysql/mariadb
SSH to the server using the Putty
login to mysql by typing
mysql -p
mysql -ucron -p1234
Step 2: Select the Database Asterisk
--copy paste in mysql cli--
use asterisk;
Step 3: Command to Check Space Used by Asterisk database
copy paste the below command in mysql cliSELECT table_schema AS "asterisk",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.TABLES
GROUP BY table_schema;
As you can see my database consumed 10gb of Disk space
Step 4: Command to check disk space consumed by each tables
Copy paste the below command to check the space occupied by each table in vicidial
SELECT table_name AS "Table",ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"FROM information_schema.TABLESWHERE table_schema = "asterisk"ORDER BY (data_length + index_length) DESC;
you will see output similar to below picture,which shows space consumed by each tables in vicidial
Step 5: Deleting the Data older than x no of days
In this step we will be deleting the data's of each table which is one year old, if you want to delete all data mention the date in which the vicidial is installed.
Deleting each table data for the date on or before 2019 dec 23:59
Run the below command in mysql console to delete old logs ie before DEC31-2019
Note: change the date as per your requirement
vicidial_url_log
DELETE FROM vicidial_url_log WHERE url_date < '2019-12-31 23:59:00';optimize table vicidial_url_log;
DELETE FROM call_log WHERE start_time < '2019-12-31 23:59:00';optimize table call_log;
vicidial_dial_log
DELETE FROM vicidial_dial_log WHERE call_date < '2019-12-31 23:59:00';optimize table vicidial_dial_log;
DELETE FROM vicidial_agent_log WHERE event_time < '2019-12-31 23:59:00';optimize table vicidial_agent_log;
Conclusion:
You need to run the Step 5 for each and every table which you want to delete of Flush data.
For Professional support reach me at skype:striker24x7
Buenas tardes, me podrias especificar para que sirve cada tabla y en que me ayuda eliminar ese espacio
Buenas tardes, me podrias especificar para que sirve cada tabla y en que me ayuda eliminar ese espacio
God Bless you brother.... your blogs are always of a great relief for service providers like us..... Stay Blessed and Happy Always...
very good post
plz need to delete too vicidial_report_log and vicidial_amd_log