Venant aussi des galleries Technet, un script intéressant est le Lync KHI importer de wilfried van oosterhout
CQM est une méthodologie pour Lync 2013 et 2010 qui vous aide à trouver et éliminer les problèmes qui affectent la qualité de l'appel et l'expérience utilisateur dans les implémentations voix.
Johan a fait un super boulot décrivant l'utilisation de cette méthodologie dans une série d'article disponible ici: http://blog.enowsoftware.com/solutions-engine/bid/186171/Lync-Call-Quality-Methodology-to-enhance-the-Call-Quality-and-User-Satisfaction-Part-I-CQM
Lync KHI importer vous permet d'importer automatiquement les résultats du script “Create_KHI_Collection.ps1”
L'outil est disponible ici: https://gallery.technet.microsoft.com/Lync-KHI-importer-0c1dbfa5
Description:
he script will read CSV files that are created with the Lync 2013 KHI script: Create_KHI_Collection.ps1
It will process the CSV files and put the data in the by Microsoft supplied excel sheet: Lync_Server_2013_Key_Health_Indicators.xlsx
A csv file is required for input. The csv file should contain all the files you want to process with the corresponding servertype.
The servertype can be any off the following:
1 Lync Front-End Server
2 Lync Mediation Server
4 Lync Front-End Server collocated with meditation server
8 Lync Edge Server
16 SQL Back-End Server
For every CSV file a new entry is added to the sheets in the excel sheet Lync_Server_2013_Key_Health_Indicators.xlsx. Existing data is preserved.
Some servers have multiple NICs, multiple drive letters etc. The script will calculate the maximum/average of each of the similar items
e.g. NICs and will take the highest maximum/average value of these.
Example how to use the script
import_khi_data.ps1 -CSVFile <csvfile> -KHIFile <excelfile>
Will run the script and only uses the servername from the csv files for identifying the servers in the Excel sheet
import_khi_data.ps1 -CSVFile <csvfile> -KHIFile <excelfile> -SingleServer
Will run the script and uses the servername + date section from the csv files for identifying the servers in the Excel sheet.
This is helpfull if you are doing an analysis over a period of time for a single server.
Requirements on the system were the script is run:
Excel 2010
Powershell
Lync_Server_2013_Key_Health_Indicators.xlsx (can be downloaded here: http://go.microsoft.com/fwlink/p/?LinkID=390677)
How to setup KHI is well explained on the web for instance here: http://guybachar.wordpress.com/2014/05/28/how-to-use-lync-key-health-indicators/
