cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3318
Views
5
Helpful
2
Replies

SQL Query for UCCE Agent/AgentTeam/SkillGroup Status's COMPLETE details (like Login, Ready, Talking, Reserved, Not-Ready, Logout...etc)

Khurshid Ali
Level 1
Level 1

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

2 Replies 2

Omar Deen
Spotlight
Spotlight
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

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: