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 [2019/05/07 08:33]
gerardorourke
vendors:cisco:uc:icm:sql [2019/06/06 11:41] (current)
gerardorourke [Number of Concurrent Agent Logged from Agent Half Hour Table]
Line 387: Line 387:
 </​code>​ </​code>​
  
-==== Number of Concurrent Agent Logged from Agent Half Hour Table ====+===== Number of Concurrent Agent Logged from Agent Half Hour Table =====
 Note: there will be some overlap, as this will document the total agent logged in, in a half hour period. So if there is a high Agent "Swap count" due to change in shift during the half hour, concurrent agent count will be lower than the figure determined here\\ Note: there will be some overlap, as this will document the total agent logged in, in a half hour period. So if there is a high Agent "Swap count" due to change in shift during the half hour, concurrent agent count will be lower than the figure determined here\\
 Remove the Where DateTime Line to get max number of agents logged in over a half hour over life of HDS data. Remove the Where DateTime Line to get max number of agents logged in over a half hour over life of HDS data.
 <code sql> <code sql>
-Select ​DateTime,Count(*)As AgentCount  +SELECT ​DateTime,COUNT(*)AS AgentCount  
-From t_Agent_Half_Hour +FROM Agent_Interval 
-Where DateTime > Getdate()-1 +WHERE DateTime > Getdate()-1 
-Group by DateTime +AND MRDomainID = '​1'​ 
-Order By AgentCount ​Desc +GROUP BY DateTime 
-</​code>​+ORDER BY AgentCount ​DESC</​code>​
  
 ** SQL Join and Case Example **\\ ** SQL Join and Case Example **\\