Office ProPlus Information

Check Disk Space

This script will output a CSV file with data around disk space utilization that can be assessed in a graphical view using new charts in Excel 2016. The folder also contains a spreadsheet that utilizes Power Query to import the data, and then a PivotTable to organize the data, so that you can display it in a Sunburst or Treemap chart.

IT Pro Scenario: This script is really designed for Excel 2016 and provides IT Pros with insight into diskspace utilization for a workstation while also exposing them to the new charts that are available in Excel 2016.

README

###Check Office Update Network Load

Determines the size of the update and quality of delta compression for an office update.

Uses Office Deployment Tool to download and install a specified starting version of Office. Then captures the current received bytes on the NetAdapter, before starting an update to the specified end version. Records the end received bytes to determine the total size of the download. Then zips the apply folder within the office updates folder to determine what the max download size would be without delta compression. Comparing these two values provides the delta compression value.

README