What PQ is an agent assigned to ?

[iptuser55]

Hi,

 I need to know what PQ an agent is assigned to

I can run separate SQL queries to show the Agent Skill target ID and a query to show the Skilltarget and Attribute assignment as well as PQ ID but I need to link the Attribute and PQ together so I can see what final PQ an agent belongs to. With we were to use Skill group we can see the member but it doesn't seem to be case with PQ`s

What is the best way , I know you can use CUIC but that is only if an agent is logged into the PQ,

thanks

[Omar Deen]

It's a sloppy query, but it'll do the job

SELECT P.FirstName, P.LastName, A.EnterpriseName, AT.AttributeValue, ATT.EnterpriseName AS Attribute, PQ.EnterpriseName AS PrecisionQueue
FROM Agent A, Agent_Attribute AT, Attribute ATT, Person P, Precision_Queue PQ, Precision_Queue_Term PQT
WHERE A.SkillTargetID = AT.SkillTargetID
AND ATT.AttributeID = AT.AttributeID
AND ATT.AttributeID = PQT.AttributeID
AND PQ.PrecisionQueueID = PQT.PrecisionQueueID
AND A.PersonID = P.PersonID