Differences

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

--- vendors:cisco:uc:icm:sql:agent [2019/08/12 09:22] – gerardorourke
+++ vendors:cisco:uc:icm:sql:agent [2020/05/25 16:15] (current) – gerardorourke
@@ Line 549: / Line 549: @@
 SG.EnterpriseName
 ORDER BY DateTime
+</code>
+===== Agent Bulk export - to help with Agent bulk Import in PCCE====
+<code sql>
+SELECT
+       userName = [LoginName]
+      ,firstName = [FirstName]
+      ,lastName = [LastName]
+      ,ecePerson = CASE([ECEPerson])
+	  WHEN 'N' THEN 'FALSE'
+	  WHEN 'Y' THEN 'TRUE'
+	  END
+      ,[screenName]
+  FROM [ucce_awdb].[dbo].[Person]
+  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>