This PowerShell script takes a Daily Peak Usage report and calculates monthly peaks per site and per product. It is provided as a workaround for the Monthly Peak Usage By Site report which does not export to CSV correctly (Defect 49377).
A CSV input file is a required parameter. If not specified, the script will prompt for a CSV file as input.
An optional output file parameter can be specified. If omitted, a CSV file with the same name and "(Monthly Peaks)" added will be created in the same directory
as the original.
Last Modified: June 21, 2017
Version: 1.0.0
Usage:
MonthlyUsageBySite -inputFile <string> [-outputFile <string>]
Important: Change the extension of the script from TXT to PS1 before executing. For security reasons, PowerShell script execution may be disabled by default. To temporarily allow the execution of scripts, run the following command from a Command Prompt, and execute the PowerShell script from this window:
PowerShell.exe -ExecutionPolicy bypass