How to reset/purge Asternic Call Center Stats tables to zero

If you want to reset the statistics on some installation and start from zero, you will need to perform a couple of steps:

First of all, you want to tell Asterisk to start a new queue activity log file (as it might have that old data you do not want to see). You can do that by rotating the logs, using this command:

#> asterisk -rx "logger reload"

Once your log file is clean, it is time to work on the Asternic side of things, first stop the asterniclog service with the command:

#> service asterniclog stop

Then you must clean/purge the tables, you can do so with this command

#> /usr/local/parselog/asterniclog -u qstatsUser -p qstatsPassw0rd -d qstats --purge

You might need to specify a different user (-u) and password (-p) if you are not using the default ones (you will get a permission error).

Confirm the action with "yes" (as it will remove with no possibility of recovery all of the stored data).

Finally, start the asterniclog service again

#> service asterniclog start