Is there any query or process to list all UCCE agents that are built in ICM

[shobhit20]

Is there any query or process to list all UCCE agents that are built in ICM. I need to know the Enterprise Name,Peripheral Name and Agent ID (Peripheral Number)

[Omar Deen]

You can gather that information from one table

SELECT EnterpriseName, PeripheralNumber, PeripheralName
FROM Agent

If you want to include their first and last name from the Person table

SELECT P.FirstName, P.LastName, A.EnterpriseName, A.PeripheralNumber, A.PeripheralName
FROM Agent A, Person P
WHERE A.PersonID = P.PersonID

If you have multiple CUCM PGs, you could also add that information in there

[shobhit20]

what would be the query for adding getting CUCM PGs. I am new to the SQL queries so seeking help

[Omar Deen]

SELECT P.FirstName, P.LastName, A.EnterpriseName, A.PeripheralNumber, A.PeripheralID, PH.EnterpriseName, A.PeripheralName
FROM Agent A, Person P, Peripheral PH
WHERE A.PersonID = P.PersonID
AND A.PeripheralID = PH.PeripheralID
ORDER BY A.EnterpriseName

You can change the ORDER BY clause to order this by whatever column you want

[shobhit20]

Thanks a lot Omar. This will be very helpful. Can I have a query which lists out all the Skill Groups that used across all the ICM scripts. It can be both in an active and previous versions of the ICM script.

[Omar Deen]

SELECT MasterScriptName = MS.EnterpriseName, SGName = SG.EnterpriseName
FROM Ref_Script_Cross_Reference SCR
LEFT JOIN Ref_Script S ON S.ScriptID = SCR.ScriptID
LEFT JOIN Ref_Master_Script MS ON MS.MasterScriptID = S.MasterScriptID
LEFT JOIN Skill_Group SG ON SG.SkillTargetID = SCR.ForeignKey
WHERE SCR.TargetType = '2' 
GROUP BY MS.EnterpriseName, SG.EnterpriseName
ORDER BY MS.EnterpriseName, SG.EnterpriseName

Please rate helpful posts