Differences

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

--- vendors:cisco:uc:icm:sql:tcd-tcv [2022/12/13 08:06] – gerardorourke
+++ vendors:cisco:uc:icm:sql:tcd-tcv [2024/04/12 18:10] (current) – [Call Type with Average Queue Time (from TCD)] gerardorourke
@@ Line 1: / Line 1: @@
-====== TCD Example ======
+====== TCD SQL ======
+===== TCD Example =====
 <code sql>
  SELECT TOP (8001)
@@ Line 787: / Line 788: @@
 --Count DESC
 Call_Type.EnterpriseName
+</code>
+===== TCD - Number of Calls for a specific interval and Total Duration of calls in seconds and also in minutes =====
+<code sql>
+SELECT
+ NumOfCalls = Count(*)
+,DurationSec = SUM(Duration)
+,DurationMin = SUM(Duration)/60
+FROM Termination_Call_Detail TCD
+WHERE
+(TCD.DateTime >= '2024-01-01 00:00:00' AND TCD.DateTime <= '2024-01-31 23:59:59')
+AND TCD.PeripheralCallType = '42'
+AND TCD.DigitsDialed = '15551234'
 </code>