Calificar mi llamada en Skype Empresarial ServerRate my Call in Skype for Business Server

Resumen: Obtenga información sobre la característica Calificar mi llamada en Skype Empresarial Server.Summary: Learn about the Rate My Call feature in Skype for Business Server.

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.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.

La ventana Calificar mi llamada ofrece un sistema de clasificación "star" y tokens predefinidos para llamadas de audio y vídeo.The Rate My Call window offers a "star" rating system and predefined tokens for audio and video calls. Además, los administradores pueden habilitar un campo personalizado para proporcionar comentarios.In addition, administrators can enable a custom field to provide feedback.

Los datos recopilados de Calificar mi llamada no se incluyen actualmente en ningún informe de supervisión existente, pero tiene un informe de supervisión independiente.Collected Rate My Call data is not currently included in any existing monitoring report, but it has a separate monitoring report. Los datos se recopilan SQL tablas a las que se puede tener acceso ejecutando SQL consultas.Data is collected in SQL tables that can be accessed by running SQL queries.

Calificar mis requisitos previos de llamadaRate my Call Prerequisites

Antes de que los usuarios de la implementación de Skype Empresarial Server puedan acceder a la funcionalidad De mi llamada, se debe implementar y configurar el siguiente conjunto de componentes: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:

  • Debe tener instalado Skype Empresarial Server (versión 9160 o posterior).You must have Skype for Business Server installed (version 9160 or higher).

  • Haga que los usuarios instalen y actualicen a la versión más reciente de Skype Empresarial y también pídales que usen la interfaz de usuario de Skype Empresarial.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.

  • Los usuarios deben estar en el grupo de servidores front-end de Skype Empresarial Server.Users must be homed on the Skype for Business Server Front End pool.

  • Debe tener una base de datos de supervisión de Skype Empresarial Server implementada y asociada a los grupos de Skype Empresarial Server.You must have a Skype for Business Server monitoring database deployed and associated to your Skype for Business Server pools.

  • Se recomienda implementar el Panel de calidad de llamadas (CQD).We recommend deploying Call Quality Dashboard (CQD).

Configurar La velocidad de mi llamadaConfigure Rate my Call

La característica Calificar mi llamada está habilitada de forma predeterminada en la directiva de cliente con la siguiente configuración:The Rate My Call feature is enabled by default in the Client policy with the following settings:

  • Porcentaje de presentación de mi llamada: 10 %Rate My Call Display Percentage - 10%

  • Calificar mi llamada permitir comentarios de usuario personalizados: deshabilitadoRate My Call Allow Custom User Feedback - disabled

Sin embargo, no es necesario realizar ninguna acción para habilitar la característica base, pero si quieres comentarios personalizados, deberás habilitarla por separado.There is no action required to enable the base feature, however but if you want custom feedback you will need to enable it separately. El siguiente Windows PowerShell cmdlet es un ejemplo de cómo habilitar los comentarios personalizados del usuario final y cambiar el intervalo del 10 % al 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 

Obtener acceso a la tasa de datos de mis llamadasAccessing Rate My Call Data

Los datos de los usuarios se recopilan en dos tablas de la base de datos de supervisión.Data from users is collected in two tables in the monitoring database.

[QoeMetrics]. [dbo]. [CallQualityFeedbackToken] - Esta tabla contiene los resultados del sondeo de tokens por parte de los usuarios finales.[QoeMetrics].[dbo].[CallQualityFeedbackToken] - this table contains results of token polling by end users.

[QoeMetrics]. [dbo]. [CallQualityFeedbackTokenDef] - Esta tabla contiene definiciones de token.[QoeMetrics].[dbo].[CallQualityFeedbackTokenDef] - this table contains token definitions.

Las definiciones de tokens se codifican de la siguiente manera:Token definitions are coded as follows:

1 1
DistortedSpeechDistortedSpeech
2 2
ElectronicFeedbackElectronicFeedback
3 3
BackgroundNoiseBackgroundNoise
4 4
MuffledSpeechMuffledSpeech
5 5
EchoEcho
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] Esta tabla contiene los resultados de sondeo de la votación "Estrella" y los comentarios de los clientes si están habilitados.[QoeMetrics].[dbo].[CallQualityFeedback] This table contains polling results from "Star" voting and customer feedback if enabled.

Se puede llamar a los datos de las tablas mediante una consulta de selección de * [Table.Name] o mediante 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.

Se pueden SQL siguientes consultas:The following SQL queries can be used:

AudioAudio

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

VideoVideo

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

Actualización de definiciones de tokensUpdating Token Definitions

The latest Skype for Business clients report new problem token IDs ( > 100) that may not be present in your [QoeMetrics].[ dbo]. Tabla [CallQualityFeedbackTokenDef].The latest Skype for Business clients report new problem token IDs (> 100) that may not be present in your [QoeMetrics].[dbo].[CallQualityFeedbackTokenDef] table. Para actualizar la tabla de base de datos con las definiciones de token más recientes, el siguiente comando SQL puede ejecutarse en la base de datos de supervisión mediante 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. Este comando reemplazará todas las entradas de [QoeMetrics]. [dbo]. Tabla [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');