Updating Skype for Business Rate My Call Token Definitions

Shortly after Skype for Business Server 2015 released, Microsoft introduced Rate My Call where users were presented with an option to rate the call they had just completed.  Users would get a pop up like the one below that allowed them to supply feedback about the call they just had:

All the rate my call data is held within the QoEMetrics database in SQL Server including the feedback tokens which give the user possible call quality issue options as shown in the checkbox list above. 

If you query the SQL database you can see the originally deployed values here:

SELECT TOP 1000 [TokenId]
      ,[TokenDescription]
  FROM [QoEMetrics].[dbo].[CallQualityFeedbackTokenDef]

TokenId    TokenDescription
1    DistortedSpeech
2    ElectronicFeedback
3    BackgroundNoise
4    MuffledSpeech
5    Echo
21    FrozenVideo
22    PixelatedVideo
23    BlurryImage
24    PoorColor
25    DarkVideo

Microsoft has since updated these values as documented here, however you need to manually update these values in your database.  Its unfortunate this is not covered in a database update via a Cumulative Update as mostly all customers I deal with would not know to update these values.   

To update them you need to run the following SQL statements in SQL Management Studio.  The following statements deletes the current tokens and recreates the expanded list of Token Definitions. 

Use QoEMetrics

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');

As you can see this updates the table to add another 28 possible tokens! 

Once these are applied you will now see the following Rate My Call notification after a video call has been made.

Comments

[JasonJWeaver]

Hey Dino, I am pretty surprised Msoft doesn't do this in the DB update....good of you to point this out. At least this version allows a bit more of drill-down. I recall that we had one customer ask for the ability to allow the end-user to turn this feature off/hide it (turned on by default, user told it helps the company but they do have the option to not see/answer it)....any thoughts on that? I'd expect not but figured I'd ask. Thanks again-

[Jason Skyberg]

Hey Dino. Thanks for the informative article. However, I have expanded the tokendefs in SQL but getting the old list offered to the client. Is there anything that needs to be done to "activate" this list? I'm 100% OnPrem with a paired EE Pool. I have updated both pools.
Thanks!

[Dino Caputo]

Jason, in my experience the client also needs to be updated to show the newer values. Update one to the latest version and see if that helps.

[Dino Caputo]

You can control how often the client sees the rate my call or turn it off completely

To change frequency use Set-CSClientPolicy -Identity [PolicyIdentity] -RateMyCallDisplayPercentage 50

To turn off or on use

Set-CSClientPolicy -Identity [PolicyIdentity] -RateMyCallAllowCustomUserFeedback $False

[wbartolo]

Just seeing this post years later but I'm having the same problem as Jason. I updated the database but am not seeing the updates issues list on my clients. I have the Sept 2020 update on the clients, and I've restarted the Skype services on all of my Front Ends. Any other ideas why the issues list doesn't have the updated entries that I created in the DB?