在 Skype for Business Server 2015 中评价我的呼叫Rate my Call in Skype for Business Server 2015

摘要: 为业务服务器 2015年了解 Skype 中的速率我的呼叫功能。Summary: Learn about the Rate My Call feature in Skype for Business Server 2015.

速率我呼叫是 Skype 业务 2015年和 2016年提供一种反馈获得最终用户的企业版的 Windows 上的客户端中的新功能。Rate My Call is a new feature in Skype for Business 2015 and 2016 clients on Windows that provides enterprises a way to get feedback from their end-users.

速率我的呼叫窗口提供"星"评级系统和用于音频和视频呼叫的预定义的令牌。The Rate My Call window offers a "star" rating system and predefined tokens for audio and video calls. 此外,管理员可以使自定义字段提供反馈。In addition, administrators can enable a custom field to provide feedback.

收集的“评价我的呼叫”数据当前不包含在现有监控报告中,但其具有单独的监控报告。Collected Rate My Call data is not currently included in any existing monitoring report, but it has a separate monitoring report. 可通过运行 SQL 查询的 SQL 表中收集数据。Data is collected in SQL tables that can be accessed by running SQL queries.

评价我的呼叫必备组件Rate my Call Prerequisites

您 Skype 业务服务器部署中的用户可以访问速率我呼叫功能之前,必须部署以下组件组,并将其配置中:Before the users in your Skype for Business Server deployment can access Rate My Call functionality, the following set of components must be deployed and configured:

  • 您必须具有 Skype 业务服务器安装 (9160 或更高版本)。You must have Skype for Business Server installed (version 9160 or higher).

  • 让您安装,并更新到 for Business 的 Skype 的最新版本,还可以询问他们使用的业务 UI Skype 的用户。Have your users install and update to the latest version of Skype for Business and also ask them to use the Skype for Business UI.

  • 用户必须驻留在业务 Server 前端池的 Skype。Users must be homed on the Skype for Business Server Front End pool.

  • 您必须具有业务服务器监控数据库部署和关联到您的业务服务器池的 Skype Skype。You must have a Skype for Business Server monitoring database deployed and associated to your Skype for Business Server pools.

  • 我们建议部署呼叫质量仪表板 (CQD)。We recommend deploying Call Quality Dashboard (CQD).

配置速率我的呼叫Configure Rate my Call

使用以下设置的客户端策略中的默认情况下启用速率我的呼叫功能:The Rate My Call feature is enabled by default in the Client policy with the following settings:

  • 评价我呼叫显示百分比-10%Rate My Call Display Percentage - 10%

  • 评价我呼叫允许自定义用户反馈-禁用Rate My Call Allow Custom User Feedback - disabled

若要启用基本功能,但是需执行任何操作,但如果您希望自定义的反馈,您需要单独启用。There is no action required to enable the base feature, however but if you want custom feedback you will need to enable it separately. 以下 Windows PowerShell cmdlet 启用自定义最终用户反馈和更改的时间间隔为 10%为 80%的示例。The following Windows PowerShell cmdlet is an example of enabling custom end user feedback and changing the interval from 10% to 80%.

Set-CSClientPolicy -Identity <PolicyIdentity> -RateMyCallDisplayPercentage 80 - RateMyCallAllowCustomUserFeedback $true 

访问我的呼叫数据速率Accessing Rate My Call Data

来自用户的数据收集监控数据库中的两个表中。Data from users is collected in two tables in the monitoring database.

[QoeMetrics]。[dbo]。[CallQualityFeedbackToken]-此表包含的最终用户的令牌轮询结果。[QoeMetrics].[dbo].[CallQualityFeedbackToken] - this table contains results of token polling by end users.

[QoeMetrics]。[dbo]。[CallQualityFeedbackTokenDef]-此表包含令牌的定义。[QoeMetrics].[dbo].[CallQualityFeedbackTokenDef] - this table contains token definitions.

令牌定义编码,如下所示:Token definitions are coded as follows:

11
DistortedSpeechDistortedSpeech
22
ElectronicFeedbackElectronicFeedback
33
BackgroundNoiseBackgroundNoise
44
MuffledSpeechMuffledSpeech
55
回声Echo
2121
FrozenVideoFrozenVideo
2222
PixelatedVideoPixelatedVideo
2323
BlurryImageBlurryImage
2424
PoorColorPoorColor
2525
DarkVideoDarkVideo
101101
Audio_SilentLocalAudio_SilentLocal
102102
Audio_SilentRemoteAudio_SilentRemote
103103
Audio_EchoAudio_Echo
104104
Audio_BackgroundNoiseAudio_BackgroundNoise
105105
Audio_LowSoundAudio_LowSound
106106
Audio_DroppedAudio_Dropped
107107
Audio_DistortedSpeechAudio_DistortedSpeech
108108
Audio_InterruptedAudio_Interrupted
109109
Audio_OtherAudio_Other
201201
Video_NoLocalVideoVideo_NoLocalVideo
202202
Video_NoRemoteVideoVideo_NoRemoteVideo
203203
Video_LowQualityVideo_LowQuality
204204
Video_FrozenVideoVideo_FrozenVideo
205205
Video_StoppedUnexpectedlyVideo_StoppedUnexpectedly
206206
Video_DarkVideoVideo_DarkVideo
207207
Video_NoAudioSyncVideo_NoAudioSync
208208
Video_OtherVideo_Other
301301
Pstn_DialPadPstn_DialPad
401401
SS_NoContentLocalSS_NoContentLocal
402402
SS_NoContentRemoteSS_NoContentRemote
403403
SS_CantPresentSS_CantPresent
404404
SS_LowQualitySS_LowQuality
405405
SS_FreezingSS_Freezing
406406
SS_StoppedUnexpectedlySS_StoppedUnexpectedly
407407
SS_LargeDelaySS_LargeDelay
408408
SS_OtherSS_Other
501501
Reliabilty_JoinReliabilty_Join
502502
Reliabilty_InviteReliabilty_Invite

[QoeMetrics]。[dbo]。[CallQualityFeedback] 如果启用,则此表包含从"Star"投票和客户反馈的投票结果。[QoeMetrics].[dbo].[CallQualityFeedback] This table contains polling results from "Star" voting and customer feedback if enabled.

可以通过调用表中的数据选择*从 [Table.Name] 查询或使用 Microsoft SQL Server Management Studio。Data from tables can be called by using a select * from [Table.Name] query or by using Microsoft SQL Server Management Studio.

可以使用以下 SQL 查询:The following SQL queries can be used:

音频Audio

SELECT
        s.ConferenceDateTime
        ,Caller.URI as Caller
        ,CallerCqf.FeedbackText 
        ,CallerCqf.Rating
        ,CallerCqfTokenDef.TokenDescription 
        ,CallerCqfToken.TokenValue
    FROM [Session] s WITH (NOLOCK)
        INNER JOIN [MediaLine] AS m WITH (NOLOCK) ON 
            m.ConferenceDateTime = s.ConferenceDateTime
            AND m.SessionSeq = s.SessionSeq                        
        INNER JOIN [AudioStream] AS a WITH (NOLOCK) ON -- only look at Audio related feedback
            a.MediaLineLabel = m.MediaLineLabel    
            and a.ConferenceDateTime = m.ConferenceDateTime 
            and a.SessionSeq = m.SessionSeq
            and a.SenderIsCallerPAI = 1                
        INNER JOIN [CallQualityFeedback] AS CallerCqf WITH (NOLOCK) ON
            CallerCqf.ConferenceDateTime  = s.ConferenceDateTime 
            and
            CallerCqf.SessionSeq = s.SessionSeq 
        INNER JOIN [CallQualityFeedbackToken] AS CallerCqfToken WITH (NOLOCK) ON
            CallerCqfToken.ConferenceDateTime  = s.ConferenceDateTime 
            and
            CallerCqfToken.SessionSeq = s.SessionSeq
            and
            CallerCqfToken.FromURI = CallerCqf.FromURI
        INNER JOIN [CallQualityFeedbackTokenDef] AS CallerCqfTokenDef WITH (NOLOCK) ON
            CallerCqfTokenDef.TokenId = CallerCqfToken.TokenId
            and
            (CallerCqfToken.TokenId < 20 or (CallerCqfToken.TokenId > 100 and CallerCqfToken.TokenId < 200)) -- only look at Audio related feedback
        INNER JOIN [User] AS Caller WITH (NOLOCK) ON
            Caller.UserKey = CallerCqf.FromURI

视频Video

SELECT
        s.ConferenceDateTime
        ,Caller.URI as Caller
        ,CallerCqf.FeedbackText 
        ,CallerCqf.Rating
        ,CallerCqfTokenDef.TokenDescription 
        ,CallerCqfToken.TokenValue
    FROM [Session] s WITH (NOLOCK)
        INNER JOIN [MediaLine] AS m WITH (NOLOCK) ON 
            m.ConferenceDateTime = s.ConferenceDateTime
            AND m.SessionSeq = s.SessionSeq                        
        INNER JOIN [VideoStream] AS v WITH (NOLOCK) ON -- only look at Video related feedback
            v.MediaLineLabel = m.MediaLineLabel    
            and v.ConferenceDateTime = m.ConferenceDateTime 
            and v.SessionSeq = m.SessionSeq
            and v.SenderIsCallerPAI = 1                
        INNER JOIN [CallQualityFeedback] AS CallerCqf WITH (NOLOCK) ON
            CallerCqf.ConferenceDateTime  = s.ConferenceDateTime 
            and
            CallerCqf.SessionSeq = s.SessionSeq 
        INNER JOIN [CallQualityFeedbackToken] AS CallerCqfToken WITH (NOLOCK) ON
            CallerCqfToken.ConferenceDateTime  = s.ConferenceDateTime 
            and
            CallerCqfToken.SessionSeq = s.SessionSeq
            and
            CallerCqfToken.FromURI = CallerCqf.FromURI
        INNER JOIN [CallQualityFeedbackTokenDef] AS CallerCqfTokenDef WITH (NOLOCK) ON
            CallerCqfTokenDef.TokenId = CallerCqfToken.TokenId
            and
           ((CallerCqfToken.TokenId > 20 and CallerCqfToken.TokenId < 100) or (CallerCqfToken.TokenId > 200 and CallerCqfToken.TokenId < 300)) -- only look at Video related feedback
        INNER JOIN [User] AS Caller WITH (NOLOCK) ON
            Caller.UserKey = CallerCqf.FromURI

更新令牌定义Updating Token Definitions

业务客户端的最新的 Skype 报告新问题令牌 Id (> 100) 可能不存在您 [QoeMetrics] 中。[dbo]。[CallQualityFeedbackTokenDef] 表。The latest Skype for Business clients report new problem token IDs (> 100) that may not be present in your [QoeMetrics].[dbo].[CallQualityFeedbackTokenDef] table. 若要使用的最新的令牌定义,更新的数据库表下方 SQL 命令可以运行使用 Microsoft SQL Server Management Studio 的监控数据库。To update the database table with the latest token definitions, the below SQL command can be run on the monitoring database using Microsoft SQL Server Management Studio. 此命令将替换 [QoeMetrics] 中的所有条目。[dbo]。[CallQualityFeedbackTokenDef] 表。This command will replace all entries in the [QoeMetrics].[dbo].[CallQualityFeedbackTokenDef] table.

DELETE FROM [CallQualityFeedbackTokenDef];
INSERT INTO [CallQualityFeedbackTokenDef] (TokenId, TokenDescription) VALUES
    (1,   N'DistortedSpeech'),
    (2,   N'ElectronicFeedback'),
    (3,   N'BackgroundNoise'),
    (4,   N'MuffledSpeech'),
    (5,   N'Echo'),
    (21,  N'FrozenVideo'),
    (22,  N'PixelatedVideo'),
    (23,  N'BlurryImage'),
    (24,  N'PoorColor'),
    (25,  N'DarkVideo'),
    (101, N'Audio_SilentLocal'),
    (102, N'Audio_SilentRemote'),
    (103, N'Audio_Echo'),
    (104, N'Audio_BackgroundNoise'),
    (105, N'Audio_LowSound'),
    (106, N'Audio_Dropped'),
    (107, N'Audio_DistortedSpeech'),
    (108, N'Audio_Interrupted'),
    (109, N'Audio_Other'),
    (201, N'Video_NoLocalVideo'),
    (202, N'Video_NoRemoteVideo'),
    (203, N'Video_LowQuality'),
    (204, N'Video_FrozenVideo'),
    (205, N'Video_StoppedUnexpectedly'),
    (206, N'Video_DarkVideo'),
    (207, N'Video_NoAudioSync'),
    (208, N'Video_Other'),
    (301, N'Pstn_DialPad'),
    (401, N'SS_NoContentLocal'),
    (402, N'SS_NoContentRemote'),
    (403, N'SS_CantPresent'),
    (404, N'SS_LowQuality'),
    (405, N'SS_Freezing'),
    (406, N'SS_StoppedUnexpectedly'),
    (407, N'SS_LargeDelay'),
    (408, N'SS_Other'),
    (501, N'Reliabilty_Join'),
    (502, N'Reliabilty_Invite');