Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
vendors:cisco:uc:icm:sql [2023/08/31 17:32] – [Average Call Values for a Agent Handled Calls for an specific interval period] gerardorourkevendors:cisco:uc:icm:sql [2024/12/06 15:03] (current) – [UCCE SQL] gerardorourke
Line 6: Line 6:
   *[[vendors:cisco:uc:icm:sql:inventory|UCCE Inventory SQL]]   *[[vendors:cisco:uc:icm:sql:inventory|UCCE Inventory SQL]]
   *[[vendors:cisco:uc:icm:sql:outbound|UCCE Outbound SQL]]   *[[vendors:cisco:uc:icm:sql:outbound|UCCE Outbound SQL]]
 +  *[[vendors:cisco:uc:icm:sql:parsing|Parsing PV Variable Example]]
   *[[vendors:cisco:uc:icm:sql:script|UCCE Script SQL]]   *[[vendors:cisco:uc:icm:sql:script|UCCE Script SQL]]
   *[[vendors:cisco:uc:icm:sql:scriptdata|UCCE Script Data SQL]]   *[[vendors:cisco:uc:icm:sql:scriptdata|UCCE Script Data SQL]]
Line 376: Line 377:
 ===== Total Calls Handled in a Half Hour===== ===== Total Calls Handled in a Half Hour=====
 <code sql> <code sql>
-SELECT SUM(CallsOfferedToHalf)As Calls ,DateTime  +SELECT SUM(CallsOffered)As Calls ,DateTime  
-FROM Peripheral_Half_Hour+FROM Peripheral_Interval
 WHERE DateTime > GetDate()-1 WHERE DateTime > GetDate()-1
 Group BY DateTime Group BY DateTime
 Order By Calls Desc Order By Calls Desc
 +</code>
  
- +<code> 
-select SUM(CallsHandledHalf) AS TotalHalfCalls,DateTime   +SELECT SUM(CallsHandled) AS TotalHandledCalls,DateTime   
-From t_Call_Type_Half_Hour +FROM Call_Type_Interval 
-Where DateTime > GetDate()-1 +WHERE DateTime > GetDate()-1 
-Group by DateTime +GROUP BY DateTime 
-Order By TotalHalfCalls Desc+ORDER BY TotalHandledCalls DESC
 </code> </code>
  
  • vendors/cisco/uc/icm/sql.1693499541.txt.gz
  • Last modified: 2023/08/31 17:32
  • by gerardorourke