PowerShell has quickly become an indispensable skill for Office 365 administrators, and if you’re like me, you are starting to gather a toolbox of useful scripts. If you are new to PowerShell for Office 365, make sure you check out our PowerShell for Office 365 site with common scenarios and sample scripts available to download.
But perhaps you are looking for some more advanced scenarios, or you’re thinking about how to streamline your Office client deployment process. If that sounds like you, check out our new community GitHub project for Office IT Pro Deployment Scripts. Office 365 experts from around the world are contributing to a collection of PowerShell scripts that are designed to automate various procedures that would normally require manual intervention from an IT pro. All of the scripts are stored in a repository out on GitHub and released under the MIT license.
While these scripts are provided “as is,” with no warranty of any kind, we have done some testing and documentation on the scripts you will find in the Master branch. Please take the time to read through the README associated with each script carefully to ensure proper use of it. The number of scripts available in the Master branch will continue to grow as we collaborate with anyone willing to help in an effort to automate tasks and add new scripts.
This project is just getting started, but here are a few scripts that we’ve already completed and are available for use:
For IT pros that are moving to a newer version of Office and want to maintain their current group policies, this is the script for you. This script automates that process to help ensure a seamless move to a newer version without a lot of manual intervention. More information can be found in the README.
We are really excited about some of the new Excel 2016 hierarchical data charts as part of the Office 2016 Preview. But, as IT pros, we know it would be much cooler to use the new charting engine to see a graphical representation of disk space utilization. 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 on GitHub 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. More information can be found in the README.
This script allows IT pros to query a local or remote workstation to find the detailed version of Office that is installed. With some tweaking, this script could be used as a solution to inventory the Office versions that are currently in your environment or quickly gather data when troubleshooting. More information can be found in the README.
This script should be used by IT pros interested in taking inventory of the modern apps installed across the organization. More information can be found in the README.
This script installs and enables the telemetry agent on computers. More information can be found in the README.
We’re working on new scripts and ideas every day to create a more streamlined approach for IT pros everywhere. Our hope is that you will take advantage of what is out there and perhaps even collaborate with us as we look to continue expanding on what is available.
Anyone is welcome to contribute to the Office IT Pro Deployment Scripts GitHub project, but we ask that you clone the Development branch to create a feature branch where you can make changes to existing scripts or create new ones. Information on contributing to the project can be found in this README.
And of course, we would love to hear your feedback and ideas on the Office 365 Network.
Thank you to our community of contributors!
A community project like this couldn’t be possible without a team of passionate experts from around the world. Special thanks to Josh Gringas, Fred Duarte, Ryan Sockalosky, Martin Nothnagel, Curtis Sawin, Michael O’Donovan, Amesh Mansukhani, Matt Fine, Andrew Morris, Michael Draftz, Adam Stigall, Amit Olkar and Russ Smith.
—Alistair Speirs, senior operations program manager for the Office 365 Deployment and Usage team