This PowerShell script takes an Application Usage By Hour report and consolidates duplicate usage entries. It then performs a summation of usage for each
machine and user pair by product and appends a column with the totals.
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 "(Consolidated)" added will be created in the same directory
as the original.
Last Modified: September 20, 2017
Version: 1.0.2
Usage:
ConsolidateUsage -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