orourke.tv - vendors:cisco:uc:icm:sql

agent

anonymous@undisclosed.example.com (Anonymous) — Mon, 25 May 2020 15:15:52 +0000

UCCE Agent SQL Agent <> Teams SELECT AgentSkillTargetID = Agent.SkillTargetID, TeamID = isNull(Agent_Team_Member.AgentTeamID,'0'), PersonalID = Agent.PersonID, AgentPeripheralNumber = Agent.PeripheralNumber, FirstName = Person.FirstName, LastName = Person.LastName, LoginName = Person.LoginName, TeamName = isNull(Agent_Team.EnterpriseName,'No Team Assigned') FROM Agent LEFT JOIN Agent_Team_Member ON Agent.SkillTargetID = Agent_Team_Member.SkillTargetID LEFT JOIN Agent_Team ON Agent_…

bucket

anonymous@undisclosed.example.com (Anonymous) — Fri, 02 Oct 2020 07:12:26 +0000

Custom Call Type - Bucket Reports Call Type Answered Custom Bucket Interval Report SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;WITH TEMP_TABLE1 AS ( SELECT CallTypeID=TCD.CallTypeID ,CASE WHEN NetQTime >=0 AND NetQTime <= 20 THEN 1 WHEN NetQTime > 20 AND NetQTime <= 60 THEN 2 WHEN NetQTime > 60 AND NetQTime <= 180 THEN 3 WHEN NetQTime > 180 AND NetQTime <= 300 THEN 4 WHEN NetQTime > 300 AND NetQTime <= 600 THEN 5 WHEN NetQTim…

config

anonymous@undisclosed.example.com (Anonymous) — Tue, 22 Nov 2022 12:25:53 +0000

UCCE Config Queries ICR_Globals is the table where system default infor is stored, such as default CallType threshold Agent SELECT Agent.SkillTargetID, Agent.PeripheralID, Agent.PeripheralNumber, Agent.PersonID, Person.FirstName, Person.LastName, Person.LoginName, Agent_Team.EnterpriseName AS AgentTeamName FROM Agent LEFT JOIN Agent_Team_Member ON Agent.SkillTargetID = Agent_Team_Member.SkillTargetID LEFT JOIN Agent_Team ON Agent_Team_Member.AgentTeamID = Agent_Team.AgentTeamID LE…

ewt

anonymous@undisclosed.example.com (Anonymous) — Thu, 02 Feb 2023 14:52:04 +0000

EWT TCD Report Note - EWT value is set on PV6 SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT TOP (8001) CallStartDateTime = DATEADD(MINUTE,-TCD.TimeZone,TCD.StartDateTimeUTC) ,CallDisconectDateTime = DATEADD(SECOND,TCD.HoldTime,(DATEADD(SECOND,TCD.TalkTime,(DATEADD(SECOND,TCD.RingTime,(DATEADD(SECOND,TCD.LocalQTime,(DATEADD(SECOND,TCD.NetQTime,(DATEADD(SECOND,TCD.DelayTime,(DATEADD(MINUTE,-TCD.TimeZone,TCD.StartDateTimeUTC))…

inventory

anonymous@undisclosed.example.com (Anonymous) — Wed, 29 Jan 2020 14:54:59 +0000

UCCE Inventory SQL This query is used against the AWDB or against the pcceInventory database and will show the configuration of the system SELECT MH.HostName, MH.MachineName, MA.Address , MS.Description, MS.ServicePort, MS.UserName, MS.Password, MS.EnablePassword FROM Machine_Host MH (NOLOCK) JOIN Machine_Address MA (NOLOCK) ON MA.MachineHostID = MH.MachineHostID JOIN Machine_Service MS (NOLOCK) ON MS.MachineAddressID = MA.MachineAddressID

lcm

anonymous@undisclosed.example.com (Anonymous) — Thu, 17 May 2018 18:56:27 +0000

LCM SQL USE LCMReports SELECT [CallOutcome] ,CASE(CallOutcome) WHEN '0' THEN 'OUTCOME_SUCCESS' WHEN '1' THEN 'OUTCOME_ABANDONED' WHEN '2' THEN 'OUTCOME_INVALID' WHEN '3' THEN 'OUTCOME_BUSY' WHEN '4' THEN 'OUTCOME_CALLBACK' WHEN '5' THEN 'OUTCOME_DNC' WHEN '6' THEN 'OUTCOME_FAX' WHEN '7' THEN 'OUTCOME_MACHINE' WHEN '8' THEN 'OUTCOME_NOANS' WHEN '10' THEN 'OUTCOME_REJECTED' WHEN '11' THEN 'OUTCOME_WRONGPARTY' WHEN '12' TH…

outbound

anonymous@undisclosed.example.com (Anonymous) — Wed, 10 Nov 2021 14:34:17 +0000

UCCE Outbound SQL Queries Dialer Detail Query SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED --USE SELECT Dialer_Detail.DateTime, --Dialer_Detail.DbDateTime, Campaign.CampaignName, --Dialer_Detail.CampaignID AS CampaignID, Query_Rule.QueryRuleName, --Dialer_Detail.QueryRuleID AS QueryRuleID, Import_Rule.ImportRuleName, --Query_Rule.ImportRuleID, --Import_Rule.FilePath, --Dialer_Detail.DialingListID AS Campai…

parsing

anonymous@undisclosed.example.com (Anonymous) — Fri, 06 Dec 2024 15:04:25 +0000

SQL Parsing PV Variable Example WITH SplitData AS ( SELECT [RecoveryKey], [DateTime], [DialedNumberString], [Variable9], value AS PartValue, ROW_NUMBER() OVER (PARTITION BY RecoveryKey ORDER BY (SELECT NULL)) AS PartNumber FROM Route_Call_Detail RCD CROSS APPLY STRING_SPLIT(Variable9, '|') WHERE Variable9 LIKE 'TST|%' AND DateTime > GetDate()-1 ) SELECT RecoveryKey, DateTime, DialedNumberString, Variable9, MAX(CASE WHEN PartNumber …

route

anonymous@undisclosed.example.com (Anonymous) — Wed, 05 Feb 2020 15:48:20 +0000

UCCE Route & TCD SQL Schema Reference: Route Error Codes Reference: Distinct ANI Query From TCD table Collection for CUIC SELECT DISTINCT TOP 3000 ANI as ID, ANI as …

script

anonymous@undisclosed.example.com (Anonymous) — Mon, 17 May 2021 14:42:02 +0000

UCCE Script Target Types Target Type Values Meaning 0 Unknown 1 Service 2 Skill Group 3

scriptdata

anonymous@undisclosed.example.com (Anonymous) — Fri, 11 Nov 2022 17:22:50 +0000

UCCE Script Data SQL How to find the Queue Priority's set in your scripts Many thanks to the Gary Fearn for the SQL and details on how to do this His website containing this info can be found here: Reference: I copied some of the SQL here - as the format from the above webpage corrupted it when I copied and pasted.

tcd-tcv

anonymous@undisclosed.example.com (Anonymous) — Fri, 12 Apr 2024 17:10:35 +0000

TCD SQL TCD Example SELECT TOP (8001) TCDRecoveryKey = TCD.RecoveryKey ,PeripheralName = Peripheral.EnterpriseName ,RecordStartDateTimeUTC = TCD.StartDateTimeUTC ,DbDateTime=TCD.DbDateTime ,CallStartDateTime = DATEADD(MINUTE,-TCD.TimeZone,TCD.StartDateTimeUTC) ,CallConnectDateTime = DATEADD(SECOND,TCD.RingTime,(DATEADD(SECOND,TCD.LocalQTime,(DATEADD(SECOND,TCD.NetQTime,(DATEADD(SECOND,TCD.DelayTime,(DATEADD(MINUTE,-TCD.TimeZone,TCD.StartDateTimeUTC))))))))) ,CallDisconectDateTime = DATEAD…

ucce-to-pcce

anonymous@undisclosed.example.com (Anonymous) — Fri, 03 Sep 2021 09:13:30 +0000

UCCE to PCCE Migration * Make sure Apache is working on all ICM servers - check via the setup url * MR PG needs to have all Peripherals configured on it and the Multimedia ones marked as Multimedia. * Names, Peripheral Name and Routing Client Name all the same and as per below:

unusedcalltypes

anonymous@undisclosed.example.com (Anonymous) — Tue, 07 May 2019 15:12:15 +0000

Unused CallTypes Calltypes configured but NOT in the Historical Interval Table SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;WITH Unused_CallTypes AS ( SELECT CT.[CallTypeID] ,CT.[EnterpriseName] ,CT.[Description] ,CT.[Deleted] ,CT.[ChangeStamp] ,CT.[DateTimeStamp] FROM [aib_awdb].[dbo].[Call_Type] CT LEFT JOIN Call_Type_Interval CTI ON CTI.CallTypeID = CT.CallTypeID Where CTI.CallTypeID …