cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
659
Views
0
Helpful
3
Replies

post call survey pcce

what is the best way to get agent id in a post call survey application in pcce

1 Accepted Solution

Accepted Solutions

janinegraves
Rising star
Rising star

This gives you a bunch of information about the agent and skill group based on the RouterCallKey and RouterCallDay:

SELECT

Agent.EnterpriseName AgentName,
Agent.PeripheralNumber AgentPeripheralNumber,
TCD.AgentSkillTargetID AgentSkillID,
TCD.SkillGroupSkillTargetID SkillGroupID,
TCD.InstrumentPortNumber AgentExtension,
TCD.CallTypeID TCD_CT_ID,
Person.LoginName AgentLoginID,
SG.EnterpriseName SGName,
CT.EnterpriseName CallTypeName


FROM L125_hds.dbo.t_Termination_Call_Detail TCD


JOIN L125_awdb.dbo.Agent Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID
JOIN L125_awdb.dbo.Person Person ON Agent.PersonID = Person.PersonID
JOIN L125_awdb.dbo.Skill_Group SG ON TCD.SkillGroupSkillTargetID = SG.SkillTargetID
JOIN L125_awdb.dbo.Call_Type CT ON TCD.CallTypeID = CT.CallTypeID


WHERE
TCD.RouterCallKeyDay = 1111
AND
TCD.RouterCallKey = 222

View solution in original post

3 Replies 3

Ramamoorthy Shanmugam
Rising star
Rising star

Hi Gaurav,

 

We are using a custom gadget with a call studio application for PCS. Or you can try the Default PCS option in PCCE.

 

Ram.S

Regards,
Ram.S

janinegraves
Rising star
Rising star

This gives you a bunch of information about the agent and skill group based on the RouterCallKey and RouterCallDay:

SELECT

Agent.EnterpriseName AgentName,
Agent.PeripheralNumber AgentPeripheralNumber,
TCD.AgentSkillTargetID AgentSkillID,
TCD.SkillGroupSkillTargetID SkillGroupID,
TCD.InstrumentPortNumber AgentExtension,
TCD.CallTypeID TCD_CT_ID,
Person.LoginName AgentLoginID,
SG.EnterpriseName SGName,
CT.EnterpriseName CallTypeName


FROM L125_hds.dbo.t_Termination_Call_Detail TCD


JOIN L125_awdb.dbo.Agent Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID
JOIN L125_awdb.dbo.Person Person ON Agent.PersonID = Person.PersonID
JOIN L125_awdb.dbo.Skill_Group SG ON TCD.SkillGroupSkillTargetID = SG.SkillTargetID
JOIN L125_awdb.dbo.Call_Type CT ON TCD.CallTypeID = CT.CallTypeID


WHERE
TCD.RouterCallKeyDay = 1111
AND
TCD.RouterCallKey = 222

Konstantin Vaksin
Cisco Employee
Cisco Employee
Pass it over variable
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:

Recognize Your Peers