Reset number of calls for agent in real time report

[bghayad]

Hello;

vicibox 7.0.3, vicidial 2.12-15, Build 160508-0139, asterisk 11.22.0-vici, Single Machine

The machine was shut down, all numbers in the real time report are reset at the timeclock in the system settings. The voicemail server IP address is the same as the vicidial machine (all in one machine). The only problem is the number of calls for each agent, this is still accumulated number and not reset, how I can reset it? It is showing that it is 190 and this is of course accumulated old calls.

I run perl /usr/share/astguiclient/AST_reset_mysql_vars.pl manually (and I know it will be executed at 1:02 every day, but this also did not reset the number of calls for the agent. So what could be the reason?

STATION | USER SHOW ID INFO | SESSIONID | STATUS | MM:SS | CAMPAIGN | CALLS | HOLD | IN-GROUP
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------
| SIP/2299 | agent1 + | 8600051 | PAUSED | 104:57 | GENERIC | 190 |

Regards
Bilal

[williamconley]

Admin->System Settings->Active Voicemail Server

This value must be set to an actual server. That server will perform campaign cleanup nightly. If you've changed the identity of that server and it no longer exists (old IP address?), then those values will not be cleaned nightly.

Good job posting your specs!

However: This is not a "general discussion", but a support request, thus I have moved it to the 'Support' Board where it belongs.

[bghayad]

Thanks William.

If you've changed the identity of that server and it no longer exists (old IP address?), then those values will not be cleaned nightly.

If I set it now to the right IP address and I do not need to wait for night to clean the numbers, how I can do this?

Regards
Bilal

[williamconley]

perhaps

Code: Select all

update vicidial_campaign_agents set calls_today='0'

this can be done on a Per Campaign basis if you look at the table.