Page 1 of 1

Pause time

PostPosted: Fri Feb 13, 2015 12:34 am
by wonderwall
installation of Goautodial 3.0 from Yum on CentOS release 5.10.1 (Final)
Installation method.
go autodial wiki 64 bit

My Hardware are as follow
Quad Processor 10 Core Westmere EX 4850 - 2.00GHz - 4 x 24MB cache
512 GB DDR3 Registered 1066
4TB x3 SATA III in RAID 5

Is it possible to see the time at which a particular agent went to pause or changed his/her state. I believe the web page does not have information like this but can i use an SQL query to get that information?

Re: Pause time

PostPosted: Fri Feb 13, 2015 7:13 am
by mflorell
All of that information is stored in the vicidial_agent_log table.

Re: Pause time

PostPosted: Fri Feb 27, 2015 9:28 am
by wonderwall
thanks mflorell,

i tried the table, it does give some information but does not give the time at which the agent changed the state. please confirm if my observation is wrong.

thanks again.

Re: Pause time

PostPosted: Fri Feb 27, 2015 9:41 am
by mflorell
The epoch fields in vicidial_agent_log will give you the epoch time of the state change. There are MySQL and PHP functions to easily turn those into date/time values.