Top 10 Office 365 PowerShell Scripts

Learn how to use PowerShell to maximize Office 365 on a daily basis.

If you’re looking to get the most out of your Office 365 subscription, we’d like to introduce you to this week’s Office 365 training topic: Microsoft PowerShell. This tool offers a whole host of options to expand all that you can do with Office 365.

What is PowerShell?

PowerShell is simply a programming language and interactive command line shell tool built specifically for Microsoft Windows. The primary focus of PowerShell is to automate a variety of system tasks such as batch processing, as well as to allow for the creation of systems management tools to automate commonly used processes.

PowerShell has more than 130 command line tools that formerly forced users to create scripts in other programming languages such as VBScript, VB, or C#.

Easy to use Office 365 PowerShell Scripts

We’ve outlined here some of the top Office 365 PowerShell scripts to ensure you’re getting the most out of this versatile programming language. Click on the title of each script to download it from Microsoft.

1. OneDriveMapper – Automatically map a SharePoint Online library or a OneDrive for Business account to a specific drive letter upon login.
2. Exchange calendar sharing matrix – This is not a script, but rather a PDF that outlines questions related to calendar data exchange between organizations.
3. Export last login date for Office 365 users to CSV – This script allows you to connect to Office 365 and generate a CSV with all your Office 365 mailbox users’ last login date and time.
4. Show all distribution groups in Office 365 – Export all users as well as their distribution group details to a CSV file.
5. Remove duplicate items – This PowerShell script will scan each folder of a mailbox and remove any duplicates.
6. Easily access Office 365 mail traffic statistics – This script gathers both inbound and outbound email statistics and exports them to a CSV file for further analysis.
7. Script to determine location of Mailboxes – Easily determine the location of your mailboxes and identify how many databases and servers your Exchange Online mailboxes are using.
8. Gauge mailbox sizes – Determine the mailbox size for each user as well as Item Count, Server Details, and much more, all exported to a CSV file.
9. Export mailbox permissions – Use this PowerShell script to export all Office 365 mailbox permissions to a CSV file.
10. Export contacts from OWA – This script allows you to export contacts in the Default contact folder from the Outlook Web App to a CSV file.

Interested in learning even more about PowerShell?

We hope these scripts above will help you to understand the versatility of PowerShell. If you’d like to learn more, browse more of our Office 365 training materials on our website or sign up for a free 7-day free trial. To talk with one of our Office 365 experts, give us a call at 877-788-1617 or email [email protected].