Report or query for all agents assigned to attribute or precision queue in UCCE

[ccoombs]

Is there a way to get a list of all agents assigned to a specific attribute or PQ??

Thank you

[Omar Deen]

You can use something simple like this query

SELECT P.FirstName, P.LastName, A.EnterpriseName, AT.AttributeValue, ATT.EnterpriseName
FROM Agent A, Agent_Attribute AT, Attribute ATT, Person P
WHERE A.SkillTargetID = AT.SkillTargetID
AND ATT.AttributeID = AT.AttributeID
AND A.PersonID = P.PersonID
AND A.EnterpriseName IN ('5000.1329894','5000.3859437','5000.2212787','5000.9871826')

Replace the Agent Enterprise Names with your own. Use the = comparison operator for one agent or the IN logical operator for multiple agents.