How to delete old call logs leads Datas in vicidial

 

Vicidial Deleting old Call Logs

How to delete old call logs leads Datas in vicidial

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

https://youtu.be/48LqIZ67oPk

  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

(if you dont know password try below command )

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 cli

SELECT table_schema AS "asterisk",

ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"

FROM information_schema.TABLES

GROUP BY table_schema;

You will get output similar to below picture

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.

Below are the top 10 tables which consumed huge disk space,vicidial_url_logcall_logvicidial_listvicidial_dial_logvicidial_admin_logvicidial_carrier_logvicidial_log_extendedvicidial_logrecording_logvicidial_agent_log

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;call_logDELETE 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;vicidial_agent_logDELETE 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:manish.kadiya