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 [2019/06/06 11:41]
gerardorourke [Number of Concurrent Agent Logged from Agent Half Hour Table]
vendors:cisco:uc:icm:sql [2020/03/31 10:44] (current)
gerardorourke [Max Logged in Agents]
Line 1018: Line 1018:
  
 ====== SIZING ====== ====== SIZING ======
 +
 +==== Max Logged in Agents ====
 +
 +<code sql>
 +SELECT [DateTime]
 +       ,[MaxNumberLoggedOnAgents]
 +
 +       FROM [vhi_awdb].[dbo].[Peripheral_Interval]
 +       WHERE DateTime > GetDate()-365
 +       ORDER BY MaxNumberLoggedOnAgents DESC
 +</code>       
 +  
 +To find Average Skills per agent - find out how many configured agents and then how many agents assigned to skills (below).
 +<code sql>  
 +/****** Script for SelectTopNRows command from SSMS  ******/
 +SELECT SGM.[SkillGroupSkillTargetID]
 +      ,SGM.[AgentSkillTargetID]
 +   ,A.EnterpriseName
 +   ,A.Deleted
 +  FROM 
 +  [vhi_awdb].[dbo].[Skill_Group_Member] SGM
 +
 +  LEFT JOIN Agent A ON SGM.AgentSkillTargetID = A.SkillTargetID
 +  Where A.Deleted = 'N'
 +</code>  
 +==== Max Queued Calls for a specific Interval ====
 +<code sql>
 +/****** Script for SelectTopNRows command from SSMS  ******/
 +SELECT [DateTime]
 +     -- ,[CallTypeID]
 +   ,CallTypeName = CT.[EnterpriseName]
 +      ,[MaxCallsQueued]
 +      ,[TimeZone]
 +      ,[RecoveryKey]
 +      ,[RouterQueueWaitTime]
 +      ,[RouterQueueCalls]
 +      ,[AvgRouterDelayQ]
 +      ,[RouterCallsAbandQ]
 +      ,[RouterQueueCallTypeLimit]
 +      ,[RouterQueueGlobalLimit]
 +      ,[CallsRouted]
 +
 +      ,[MaxCallWaitTime]
 +      ,[ReservationCalls]
 +  FROM [vhi_awdb].[dbo].[Call_Type_Interval] CTI
 +  --Where DateTime > GetDate()-365
 +  LEFT JOIN Call_Type CT ON CT.CallTypeID=CTI.CallTypeID
 +  Where CTI.DateTime = '2019-08-12 12:30:00'
 +  AND CTI.MaxCallsQueued > 0
 +  ORDER BY MaxCallsQueued ASC
 +
 +</code>
  
 ==== Busiest Interval by CallType ==== ==== Busiest Interval by CallType ====