Page 1 of 1

alert after x amount of time on pause

PostPosted: Sun Aug 14, 2016 1:34 am
by ambiorixg12
Hi I would like to generate some event or alert when agent's pause time is greater than > 10 minutes. I dont think that such option exists on vicidial, but my question is does the paused time is saved on some DB table, because if so I could write a php script that do the job runing through a cron job.

Re: alert after x amount of time on pase

PostPosted: Sun Aug 14, 2016 6:23 am
by mflorell
There is an option to log an agent out after they are on pause for X number of seconds, Agent Pause Max Seconds -If this is set to greater than 0, and the agent has not gone out of PAUSED status in this number of seconds, the agent will automatically be logged out of the agent screen. Default is 0 for disabled.

Other than that, the amount of paused seconds can be derived from the vicidial_live_agents table.

Re: alert after x amount of time on pause

PostPosted: Sun Aug 14, 2016 11:43 am
by Rogger
Hello,
This option suggested, affects all types of breaks, as in my case needed to treat the types of breaks at different times, I used the database and API, works very well.

Re: alert after x amount of time on pause

PostPosted: Sun Aug 14, 2016 3:19 pm
by ambiorixg12
Thanks to all for the recommendations, Matt on my DB structure there is no such table vicidial live_agents the only table holding agent pause statuses is vicidial_agent_log

Roger could you please tell me what tables are you using to complete this task ?
Rogger wrote:Hello,
This option suggested, affects all types of breaks, as in my case needed to treat the types of breaks at different times, I used the database and API, works very well.



Vicibox



VERSION: 2.12-560a
BUILD: 160617-1427
© 2016 ViciDial Group

Re: alert after x amount of time on pause

PostPosted: Sat Sep 17, 2016 3:59 pm
by williamconley
vicidial_live_agents is just after vicidial_list_update_log