cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
700
Views
5
Helpful
2
Replies

ICM Scripting

Arjun Raju
Level 1
Level 1

I need to find ICM scripts which are not referenced by any other scripts nor scheduled by any call types.

 

Please help with the SQL query

 

Regards,

Arjun Raju

2 Replies 2

Basudev_Cisco
Level 1
Level 1

I dont think there is any easy way to find the Script Reference. AWDB Script tables executes current active versions of the scripts, where as there is chance that your older Script versions still have reference of other scripts/ call types/ skills. So the only way is to check in Script Reference in Config Manager -> select appropriate target and check.

piyush aghera
Spotlight
Spotlight

As Basudev said, there is no easy way but you can use below two queries and some excel work to identify which scripts are not referenced by any call types:

 

1. Below query returns the mapping of DN-> CT -> script:

SELECT dn.DialedNumberString, dn.EnterpriseName AS Dialed_Number_Name, ct.EnterpriseName AS Call_Type_Name, ms.EnterpriseName AS Script_Name
FROM Dialed_Number dn
LEFT OUTER JOIN Dialed_Number_Map dnm ON dn.DialedNumberID = dnm.DialedNumberID
LEFT OUTER JOIN Call_Type ct ON dnm.CallTypeID = ct.CallTypeID
LEFT OUTER JOIN Call_Type_Map ctm ON ct.CallTypeID = ctm.CallTypeID
LEFT OUTER JOIN Master_Script ms ON ctm.MasterScriptID = ms.MasterScriptID

2. Below query returns list of all the ICM routing scripts:

select * from Master_Script where ScriptType='1'

 

You can compare output of these two queries using excel and find out which scripts are not mapped to any call types.

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: