Differences

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

--- vendors:cisco:uc:icm:sql:unusedcalltypes [2019/05/07 15:50] – 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 58: / Line 69: @@
       ,CT.[DateTimeStamp]
   FROM [aib_awdb].[dbo].[Call_Type] CT
-  LEFT JOIN Call_Type_Interval CTI ON CTI.CallTypeID = CT.CallTypeID
+  --LEFT JOIN Call_Type_Interval CTI ON CTI.CallTypeID = CT.CallTypeID
-  WHERE CT.Deleted = 'N' AND CTI.CallTypeID IS NULL
+  WHERE CT.Deleted = 'N' --AND CTI.CallTypeID IS NULL
  )
@@ Line 83: / Line 94: @@
 Select
-	   UCT.[CallTypeID]
+       UCT.[CallTypeID]
       ,UCT.[EnterpriseName]
       ,UCT.[Description]