Differences

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

--- vendors:cisco:uc:icm:sql:agent [2020/01/30 12:49] – [Agent Count Logged into a Skillgroup for a certain time interval over a number of days] gerardorourke
+++ vendors:cisco:uc:icm:sql:agent [2020/05/25 16:15] (current) – gerardorourke
@@ Line 554: / Line 554: @@
 <code sql>
 SELECT
-       username = [LoginName]
+       userName = [LoginName]
       ,firstName = [FirstName]
       ,lastName = [LastName]
@@ Line 561: / Line 561: @@
 	  WHEN 'Y' THEN 'TRUE'
 	  END
-      ,[ScreenName]
+      ,[screenName]
   FROM [ucce_awdb].[dbo].[Person]
-  WHERE ECEPerson = 'N'
+  WHERE
+  ECEPerson = 'N' AND
+  Deleted = 'N'
+  ORDER BY LoginName COLLATE Latin1_General_CI_AS
 </code>
+===== Supervisors <> Team SQL =====
+<code sql>
+/****** Script for SelectTopNRows command from SSMS  ******/
+SELECT
+  AgentTeamID = ATS.[AgentTeamID]
+ ,AgentTeamName = AT.EnterpriseName
+ ,AgentEntepriseName = A.EnterpriseName
+ ,AgentSkillTargetID = ATS.[SupervisorSkillTargetID]
+  FROM
+  [vhi_awdb].[dbo].[Agent_Team_Supervisor] ATS,
+  Agent A,
+  Agent_Team AT
+  WHERE
+  ATS.AgentTeamID = AT.AgentTeamID AND
+  ATS.SupervisorSkillTargetID = A.SkillTargetID
+  AND A.EnterpriseName like '%eirsupp%'
+</code>