Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| vendors:cisco:uc:icm:sql:agent [2020/01/30 13:07] – [Agent Bulk export - to help with Agent bulk Import in PCCE] gerardorourke | vendors:cisco:uc:icm:sql:agent [2020/05/25 16:15] (current) – gerardorourke | ||
|---|---|---|---|
| Line 568: | Line 568: | ||
| ORDER BY LoginName COLLATE Latin1_General_CI_AS | ORDER BY LoginName COLLATE Latin1_General_CI_AS | ||
| </ | </ | ||
| + | |||
| + | |||
| + | ===== Supervisors <> Team SQL ===== | ||
| + | <code sql> | ||
| + | /****** Script for SelectTopNRows command from SSMS ******/ | ||
| + | SELECT | ||
| + | AgentTeamID = ATS.[AgentTeamID] | ||
| + | , | ||
| + | , | ||
| + | , | ||
| + | | ||
| + | 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 ' | ||
| + | </ | ||