CQM is the response of your Prayers. Most mushrooms that you can find in your platform can have a sense thanks to Call Quality Methodology.
This tool help you to obtain full statistics of your stream sessions. You can to obtain statistics from Call Quality, bad devices, bad streams, user rates, and more. It is a great tool (THANK YOU MICROSOFT!)
Here, you can look up more usefull information (and download links) of the tool:
Now I explain you some instructions that you can follow to deploy the tool in your platform.
First, you may download the tool from here.
The tool is just a Powershell Script that obtain data from SQL Server, It doesn’t touch anything, doesn’t modify anything.So you can save it on any computer or server in you network. I recommend to save it on a computer that you use for remote management. Instead you can save it on your SQL Server if you want (remember,the tool doesn’t modify anything, it is safe).
When you will have it into a directory on your machine (for instance E:\CSResources), you can start using the tool.
You will have the following files and folders (all of them are important).
As you can see, you will have an excel named “Microsoft Call Quality Methodology Scorecard for Skype for Business Server v15”, be patient, this file is not important now. You can use it after you get the information.
Ok, so now you need to open a Windows Powershell. Browse to CQM directory
Next, you need to known what date format you have into your SQL. To known it, you need to execute “getSQLDateFormat.ps1” script typing your SQL Instance.
Next, you can to obtain data with the other script CQM.ps1. You will need to type the first day that you want to collect data. after that, you need to indicate to the script the instance as the same mode as you typed it on “getSQLDateFormat.ps1”.
After CQM have collected data you can look up it at “Results” directory. Similar as the following
Inside the folder, you can see all querys discovered.
Ok, Firsts steps are over. Now you need to ordenate the information. How you can sort this data?
Now you need to open “Microsoft Call Quality Methodology Scorecard for Skype for Business Server v15” after that, you need to allow macros and enable editing. When you have complete this steps you should have an excel as the following:
Next step is to import CQM Query Results, to do that you need click on “import CQM Query Results” and then search the exported folder that you type on CQM.ps1 (DataRoot option)
As you can see, more than one tab are available now, for example “Endpoint_0_Device”,”Endpoint_1_system”, …
Next step is to generate all informs. “stream Distribution Charts”, “Trending charts”, “Reliability Charts” and “Top issues”. If you have follow all steps correctly, you must have an inform as the following:
If you followed all steps and you arrived here, you got it! Please, read Microsoft Call Quality Methodology.docx for more detailed information. This tool have a lot of possibilities.
I hope this information will be usefull for you.