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

摘要: 了解有关 Skype for Business 服务器中我的通话功能的费率。Summary: Learn about the Rate My Call feature in Skype for Business Server.

评价我的通话是 Skype for business 2015 和2016客户端的一项新功能, 可为企业提供从最终用户获得反馈的途径。Rate My Call was 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.

"通话费率" 窗口为音频和视频呼叫提供 "star" 分级系统和预定义令牌。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 for Business 服务器部署中的用户可以对我的呼叫功能进行评级之前, 必须部署和配置以下组件集: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 for Business 服务器 (版本9160或更高版本)。You must have Skype for Business Server installed (version 9160 or higher).

  • 让你的用户安装和更新到最新版本的 Skype for Business, 并让他们使用 Skype for Business UI。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.

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

  • 必须已部署 Skype for business 服务器监视数据库并将其与 Skype for business 服务器池相关联。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
21日21
FrozenVideoFrozenVideo
2222
PixelatedVideoPixelatedVideo
2323
BlurryImageBlurryImage
24
PoorColorPoorColor
二十五25
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.

可以使用select * from [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 for Business 客户端报告您的 [> QoeMetrics] 中可能不存在的新问题令牌 id (100)。[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. 若要使用最新的标记定义更新数据库表, 可使用 Microsoft SQL Server Management Studio 在监视数据库上运行以下 SQL 命令。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');