The script will read CSV files that are created with the Lync 2013 KHI script: Create_KHI_Collection.ps1 (part of the Lync server networking guide v2.2)

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: https://www.microsoft.com/en-us/download/details.aspx?id=39084)

   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/

 

Version history

 0.3 - Script updated to support version 2.2 of the networking guide. Previous script was based on version 2 of the networking guide

 0.2 - Added server memory in CSV file to calculate available memory percentage
     - Corrected values of below counters to convert from seconds to milliseconds. Thanks to Guy Bachar for the feedback.
    \PhysicalDisk(*)\Avg. Disk sec/Read
          \PhysicalDisk(*)\Avg. Disk sec/Write
 
 0.1 - First version of the script
    The 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