cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

251
Views
5
Helpful
2
Replies
Beginner

ICM Scripting

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

Everyone's tags (1)
2 REPLIES 2
Beginner

Re: ICM Scripting

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.

Highlighted
Enthusiast

Re: ICM Scripting

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.

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here