cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
449
Views
10
Helpful
2
Replies

UCCE SQL Query to find call types set at script level

harresh123
Beginner
Beginner

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?

1 Accepted Solution

Accepted Solutions

AnoopKrishnan123
Beginner
Beginner

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**

View solution in original post

2 Replies 2

bill.king1
VIP Advocate VIP Advocate
VIP Advocate

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
Beginner
Beginner

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**

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