Index to vicidial_agent_log

[ekaftan]

Hi,

I need to monitor in real time the pause code of the agents. So far (in 2.0.4, I've not upgraded yet) the only place I can find it is in the table vicidial_agent_log.

Can I add a couple of indexes to that table to be able to search for a particular agent, or is there a risk of too much mysql io?

Is there another place where the pause code is stored? Did something change in 2.0.5 that would make this easier for me?

Thanks.

[mflorell]

Pause code is only stored in vicidial_agent_log.

An index on that field of that table should be fine.

I would strongly recommend upgrading to 2.0.5(2.0.5.1rc1 actually), there are a lot of bugs fixed related to pause codes in that update.