Vic,
thank you for explaining about tables written by stat server. There is a lot of useful information there, isn’t it?
I noticed that STATUS table has agentdbid, status, and connid in it. After reading the manual, I now know that this table is updated each time there is some sort of change in agent status. Status field shows different states for the agent, such as:
WaitForNextCall (Ready) 4
OffHook 5
CallDialing 6
CallRinging 7
NotReadyForNextCall 8
AfterCallWork 9
CallOnHold 13
CallUnknown 18
CallConsult 19
CallInternal 20
CallOutbound 21
CallInbound 22
LoggedOut 23
Can this be used to track short-abandoned calls? CallRinging but no Off-Hook? Does there exist an SQL to find all the calls that have this and then listing onnID to identify those calls?
Thank you so much!
M.M.