本文介绍了Shoretel-拨出电话查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试找出哪个表/列存储了有关座席进行的去电数量的信息.我可以使用下面的查询来获得拨入电话的总数,但是我不确定如何获得拨出电话的总数.数据库是MySQL,应用程序是Shoretel.
I am trying to figure out which table/column stores the information about the number of outgoing calls an agent has made. I can get the total number of incoming calls using the query below, but I am not sure about how to get total outgoing calls. The database is MySQL and the application is Shoretel.
任何帮助将不胜感激!
SELECT sum(a_acd_answered) FROM ecc.agent, ecc.agnto where agent.agent_id = agnto.agent_id and a_date >= ''2014-03-09'' and a_date <= ''2014-03-15'' and agnto.agent_id = 9'
推荐答案
如果您想知道统计数字,请在下面查询:
If you want to know the statistical number, then here is the query:
Select
(sum(ag.a_nacd_out)+sum(ag.a_internal_nacd_out)+sum(ag.a_external_nacd_out))Outbound
from ecc.agnto ag
join ecc.agent a on a.agent_id=ag.agent_id
where a.agent_id=57
and a_date between '2014-01-01' and '2014-01-10'
group by a.agent_id;
如果您想了解呼叫详细信息,则最好通过座席分机使用shorewarecdr
模式.检查以下查询.
If you want to know the call details info, then it is better to use shorewarecdr
schema by agent extension. Check the below query.
SELECT ID,CallerID,StartTime,EndTime,Extension,DialedNumber,CallType
FROM
shorewarecdr.`call`
where
Extension=1331
and date(StartTime) between '2014-01-01' and '2014-01-01'
and CallType=3;
注意:CallType=3
用于出站.
这篇关于Shoretel-拨出电话查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!