04-07-2017 11:08 AM - edited 03-14-2019 05:12 PM
Hello,
Can anyone help here with below detail:
SQL Query for UCCE Agent/AgentTeam/SkillGroup Status's COMPLETE details (like Login, Ready, Talking, Reserved, Not-Ready, Logout...etc)??
Thanks
Khurshid Ali
04-08-2017 10:30 AM
SELECT Agent_Real_Time.DateTime AS DateTime,
Agent_Real_Time.AgentState AS AgentState,
CASE Agent_Real_Time.AgentState
WHEN '0' THEN 'Logged Out'
WHEN '1' THEN 'Logged On'
WHEN '2' THEN 'Not Ready'
WHEN '3' THEN 'Ready'
WHEN '4' THEN 'Talking'
WHEN '5' THEN 'Work Not Ready'
WHEN '6' THEN 'Work Ready'
WHEN '7' THEN 'Busy Other'
WHEN '8' THEN 'Reserved'
WHEN '9' THEN 'Unknown-9'
WHEN '10' THEN 'Calls On Hold'
WHEN '11' THEN 'Active'
WHEN '12' THEN 'Paused'
WHEN '13' THEN 'Interrupted'
WHEN '14' THEN 'Not Active'
ELSE 'UNKNOWN'
END AS AgentStateName,
Person.FirstName AS FirstName,
Person.LastName AS LastName,
Agent.EnterpriseName AS EnterpriseName,
Agent_Team.EnterpriseName AS AgentTeam,
Agent_Real_Time.Extension AS Extension
FROM Agent_Team, Agent_Team_Member, Agent_Real_Time
INNER JOIN Agent ON Agent_Real_Time.SkillTargetID = Agent.SkillTargetID
INNER JOIN Person ON Agent.PersonID = Person.PersonID
WHERE Agent.SkillTargetID = Agent_Team_Member.SkillTargetID
AND Agent_Team_Member.AgentTeamID = Agent_Team.AgentTeamID
ORDER BY Person.LastName
04-10-2017 06:04 AM
Thanks [@Omar.Deen] ,
This query is to check for only Real Time users.
I am looking for Query, which can give COMPLETE ACTIVITY on CTI OS of user's whole day activity, since he/she came office(login) till he left (final logout).
Hope I am understood/ clear now.
Thanks for your time and zeal. Much appreciated.
Regards
Khurshid Ali
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide