Differences

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

Link to this comparison view

Both sides previous revision Previous revision
vendors:cisco:uc:icm:sql:unusedcalltypes [2019/05/07 16:10] – gerardorourkevendors:cisco:uc:icm:sql:unusedcalltypes [2019/05/07 16:12] (current) – gerardorourke
Line 9: Line 9:
 ( (
 SELECT  SELECT 
-    CT.[CallTypeID]+       CT.[CallTypeID]
       ,CT.[EnterpriseName]       ,CT.[EnterpriseName]
       ,CT.[Description]       ,CT.[Description]
Line 52: 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> <code sql>
 SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON  SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON 
Line 60: Line 62:
 ( (
 SELECT  SELECT 
-    CT.[CallTypeID]+       CT.[CallTypeID]
       ,CT.[EnterpriseName]       ,CT.[EnterpriseName]
       ,CT.[Description]       ,CT.[Description]
Line 92: Line 94:
    
 Select  Select 
-    UCT.[CallTypeID]+       UCT.[CallTypeID]
       ,UCT.[EnterpriseName]       ,UCT.[EnterpriseName]
       ,UCT.[Description]       ,UCT.[Description]
  • vendors/cisco/uc/icm/sql/unusedcalltypes.1557241829.txt.gz
  • Last modified: 2019/05/07 16:10
  • by gerardorourke