SELECT TOP (100) [acf_id]
,[acf_agentSkill]
,[acf_agentUserFk]
,[acf_dnisFk]
,[acf_callCenterFk]
,[acf_callHeldCount]
,[acf_callHeldDuration]
,[acf_callTotalDuration]
,[acf_callRingDuration]
,[acf_callTalkDuration]
,[acf_callStartedDateUTC]
,[acf_callStartedTimeUTC]
,[acf_callStartedDateLocal]
,[acf_callStartedTimeLocal]
,[acf_callReleasedDateUTC]
,[acf_callReleasedTimeUTC]
,[acf_callReleasedDateLocal]
,[acf_callReleasedTimeLocal]
,[acf_status]
,[acf_key]
,[acf_accountId]
,[acf_callId]
,[acf_networkCallId]
,[acf_remoteNumber]
,[acf_numberCalled]
,[acf_creationTimestamp]
,[acf_lastUpdateTimestamp]
,[acf_callAnsweredTimestamp]
,[acf_callStartedTimestamp]
,[acf_callHeldTimestamp]
,[acf_callResumedTimestamp]
,[acf_callReleasedTimestamp]
,[acf_eipId]
,[acf_nonCallCenterCall]
,[acf_direction]
,[acf_callType]
,[acf_redirectLocation]
,[acf_redirectNumber]
,[acf_wrapUpDuration]
,[acf_wrapUpExitTimestamp]
,AU.[bud_broadsoftUserId] AS agentUserId
,QU.[bud_broadsoftUserId] AS queueUserId
FROM [dbo].[BroadsoftCCAgentCallFact] AS CF LEFT OUTER JOIN [dbo].[BroadsoftUserDimension] AS AU ON CF.[acf_agentUserFk] = AU.[bud_id]
LEFT OUTER JOIN [dbo].[BroadsoftCallCenterDimension] AS QJ ON CF.[acf_callCenterFk] = QJ.[bccd_id]
LEFT OUTER JOIN [dbo].[BroadsoftUserDimension] AS QU ON QU.[bud_broadsoftFQUserId] = QJ.bccd_userId
|