Differences

This shows you the differences between two versions of the page.

--- vendors:cisco:uc:icm:sql:script [2019/05/08 16:11] – [Enterprise Skillgroups in the latest version of a script] gerardorourke
+++ vendors:cisco:uc:icm:sql:script [2021/05/17 15:42] (current) – [Calltypes] gerardorourke
@@ Line 172: / Line 172: @@
   ORDER BY MS.EnterpriseName
 </code>
+==== Details Scripts which have a Goto Script and which script configured as the Goto Script ====
+<code sql>
+SELECT
+      OriginatingScript = MS1.EnterpriseName
+	  ,SCR.[ScriptID]
+	  ,S.MasterScriptID
+      ,SCR.[LocalID]
+      ,SCR.[TargetType]
+      ,SCR.[ForeignKey]
+	  ,GotoScript = MS2.EnterpriseName
+  FROM [vhi_awdb].[dbo].[Script_Cross_Reference] SCR
+  LEFT JOIN Script S ON S.ScriptID = SCR.ScriptID
+  LEFT JOIN Master_Script MS1 ON MS1.MasterScriptID = S.MasterScriptID
+  LEFT JOIN Master_Script MS2 on MS2.MasterScriptID = SCR.ForeignKey
+  WHERE SCR.TargetType = '20'
+  --AND ForeignKey = '5642'
+  ORDER BY MS2.EnterpriseName
+</code>