Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| vendors:cisco:uc:icm:sql:agent [2020/01/30 12:59] – [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 554: | Line 554: | ||
| <code sql> | <code sql> | ||
| SELECT | SELECT | ||
| - | | + | |
| ,firstName = [FirstName] | ,firstName = [FirstName] | ||
| ,lastName = [LastName] | ,lastName = [LastName] | ||
| Line 561: | Line 561: | ||
| WHEN ' | WHEN ' | ||
| END | END | ||
| - | ,[ScreenName] | + | ,[screenName] |
| FROM [ucce_awdb].[dbo].[Person] | FROM [ucce_awdb].[dbo].[Person] | ||
| WHERE | WHERE | ||
| 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 ' | ||
| + | </ | ||