How to: Add-on for call volume forecasting?

I am considering implementing a “call volume forecasting add-on” for Asterisk. Unfortunately, I am quite new to Asterisk, and I would greatly appreciate some community feedback in order to move in the right direction.

First, if I understand correctly, logs are stored in /var/log/asterisk/queue_log ; and possibly some “tricks” may have to be applied to prevent log rotation.

Then I need to access the call logs from a remote location in a programmatic manner:

  • One idea would be to copy the file into an Apache directory and to protect it through .htaccess
  • Another idea (probably better) would be to inject the logs into a MySQL database.

What would you suggest?

Also, if what feature and/or format of reports would you suggest for such a forecasting add-on?

Thanks in advance,
Joannès workload forecasting