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.
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-
Posted by: JasonJWeaver | December 20, 2017 at 10:25 AM
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!
Posted by: Jason Skyberg | February 05, 2018 at 02:30 PM
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.
Posted by: Dino Caputo | February 12, 2018 at 03:20 PM
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
Posted by: Dino Caputo | February 12, 2018 at 03:23 PM
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?
Posted by: wbartolo | October 26, 2020 at 09:58 AM