vicidial.org

Hey guys, i run a couple of intense dialing clusters and I archive logs on a daily basis. I mean not just ADMIN_archive_log_tables.pl --daily but ADMIN_archive_log_tables.pl --days=1


Now I'm dealing with HUGE archive tables, I have never use the trim archive options, certainly it is what I am looking for. But I would like to know which reports uses call_log table in order to set a good lifecycle for my trimming process. So far i have only identified that the user_stats report uses, but I can't even figure out where does it use it. So I don't know exactly how trimming that table is going to affect on reports.

I hope someone can help, have a great day everybody.

The "call_log" table really isn't used much in reporting. What you will see in the reports like "User Stats" are only there when it is in DID-mode, not for actual User stats. The call_log table is usually one of the first ones we recommend that clients purge if they need to.

Awsome , Thank you so much.