Differences

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

--- vendors:cisco:uc:icm:sql:unusedcalltypes [2019/05/07 16:07] – [CallTypes Not in Active Scripts OR Dialed Number Table] gerardorourke
+++ vendors:cisco:uc:icm:sql:unusedcalltypes [2019/05/07 16:12] (current) – gerardorourke
@@ Line 3: / Line 3: @@
 ==== Calltypes configured but NOT in the Historical Interval Table ====
 <code sql>
+SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
+SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
 ;WITH Unused_CallTypes AS
 (
 SELECT
-	   CT.[CallTypeID]
+       CT.[CallTypeID]
       ,CT.[EnterpriseName]
       ,CT.[Description]
@@ Line 22: / Line 25: @@
 ==== Active Script Calltypes ====
 <code sql>
+SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
+SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
 ;WITH ActiveScriptCallTypes AS
 (
@@ Line 46: / Line 52: @@
-==== CallTypes Not in Active Scripts OR Dialed Number Table====
+===== CallTypes Not in Active Scripts OR Dialed Number Table=====
+Note - Remove Comments "--" in SQL below if you want to also check these CallTypes do not appear in the Calltype Historical Tables
 <code sql>
+SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
+SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
 ;WITH Unused_CallTypes AS
 (
 SELECT
-	   CT.[CallTypeID]
+       CT.[CallTypeID]
       ,CT.[EnterpriseName]
       ,CT.[Description]
@@ Line 83: / Line 94: @@
 Select
-	   UCT.[CallTypeID]
+       UCT.[CallTypeID]
       ,UCT.[EnterpriseName]
       ,UCT.[Description]