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:tcd-tcv [2022/12/13 08:07] – gerardorourkevendors:cisco:uc:icm:sql:tcd-tcv [2024/04/12 18:10] (current) – [Call Type with Average Queue Time (from TCD)] gerardorourke
Line 788: Line 788:
 --Count DESC --Count DESC
 Call_Type.EnterpriseName 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> </code>
  • vendors/cisco/uc/icm/sql/tcd-tcv.1670918832.txt.gz
  • Last modified: 2022/12/13 08:07
  • by gerardorourke