QueueMetrics forum

QueueMetrics => MySQL storage and Qloaderd/Uniloader => Topic started by: gopal2k on December 03, 2013, 09:49:31

Title: Changing email of all agents
Post by: gopal2k on December 03, 2013, 09:49:31

I would like to change the email column for all my agents configured in queuemetrics. The agents might be around 1000 numbers, I see in MySQL this table named "agenti_noti" all the agents information.

By using replace function in MySQL, if I change the value of email "descr_agente" will that be sufficient?

Please advise.

Thanks.

Title: Re: Changing email of all agents
Post by: QueueMetrics on December 06, 2013, 15:48:46

What do you mean by "email" for an agent? the one you refer to is the description.
After you do the changes, wait a few minutes for QM to invalidate caches ad start reloading.

Title: Re: Changing email of all agents
Post by: gopal2k on March 03, 2014, 09:38:56

Sorry for my delayed reply. Yes the Agent description... while creating agents.

Actually I have so many agents, so will the replace command in mysql is sufficient to change bunch of email address?

Thanks.

Title: Re: Changing email of all agents
Post by: mirkox on March 03, 2014, 15:29:37

Hi,

yes, just replace the values (and log out and in in QueueMetrics to see them updated).

I'd do a dump of the table before doing that, just to be on the safe side.

Mirko