UCCE SQL Query to find call types set at script level

[harresh123]

Hi Guys,

in most cases we use the  "Set Call Type" node right before the queue to skill group node along with several other call types at diff intervals. I would like to pull all my call types references in scripts along with script name so I could use specific ones for reporting. Is there a query I could run that gives me all the call types referenced in a script?

[bill.king1]

So the basic way would be to look at the Administration/Script Reference/Call Type in Configuration Manager tool in UCCE.
If you're looking for something bigger, you'd probably need to look at something like the visualization tool that was developed and referenced here by a third party/poster.

https://community.cisco.com/t5/contact-center/target-requery-report/td-p/4408337

[AnoopKrishnan123 · Accepted solution]

You can run this query to find all the Call Types in the Active script 

SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

;WITH ActiveScriptCallTypes AS
(
SELECT
MasterScriptName = MS.EnterpriseName
,CurrentVersion = MS.CurrentVersion
,ScriptVersion = S.Version
,CT.EnterpriseName
,ScriptID = SCR.[ScriptID]
,[LocalID] = SCR.LocalID
,[TargetType] = SCR.TargetType
,[ForeignKey] = SCR.ForeignKey

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 Call_Type CT ON CT.CallTypeID = SCR.ForeignKey

WHERE SCR.TargetType = '7' AND (CurrentVersion = S.Version)
)

SELECT * FROM ActiveScriptCallTypes

**Please rate Answer if Helpful**