The essential admin's guide to Office 365 PowerShell
A comprehensive collection of articles, videos and more, hand-picked by our editors
Exchange Online, Azure Active Directory and Office 365 all work together in many ways, and to efficiently administer...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
them, you should learn to work with PowerShell.
If your company has Office 365, or just Exchange Online, you probably know how to administer each service via the Office 365 portal already. However, to make changes in bulk, you need the help of PowerShell scripting. Here's how to make a connection to Office 365 and Exchange Online with PowerShell.
PowerShell for Office 365
To connect to Office 365 with PowerShell requires a couple prerequisites that don't come installed on Windows by default: the Microsoft Online Services Sign-In Assistant and the Microsoft Azure Active Directory (AD) PowerShell Module. These are both Windows Installer MSI files that you must download and install, accepting the defaults. You only have to install these once.
Note: This article is based on use of version 0.98 of the Azure AD module.
Ensure that PowerShell can see the Azure Active Directory PowerShell module before starting. Open up a PowerShell console type Get-Module –Name MSOnline -ListAvailable (see figure 1).
Once you confirm that the Azure AD module is installed correctly, run the Connect-MsolService cmdlet. This cmdlet attempts to create a connection with Azure AD. Office 365 depends on Azure AD for its user database and authentication.
When you run Connect-MsolService, you'll see a prompt to provide your credentials (see figure 2).
You can also pass a PSCredential object to Connect-MsolService by assigning a variable to a credential object such as $MyCredential = Get-Credential and then passing that credential to Connect-MsolService by the –Credential parameter.
If all goes well, you'll be back in the PowerShell console with a connection made for Office 365. As a test, run Get-MsolDomain. This should return each of the domains you have registered with Office 365.
PowerShell for Exchange Online
Connecting to Exchange Online with PowerShell is easy -- it does not require any extra software to install. This connection simply relies on PowerShell's remote sessions to connect to the Exchange Online endpoint and to import all of the available cmdlets.
First, create a PSCredential object using Get-Credential:
$UserCredential = Get-Credential
Next, build a new PowerShell remoting session with the Exchange Online endpoint, passing it your username/password credential. This will establish a connection to Exchange Online for PowerShell:
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic –AllowRedirection
At this point, $Session contains all of the cmdlets needed to work with Exchange Online, but you need to bring them into your local session to use them. Apply the Import-PSSession cmdlet and specify the session you just built. This is called implicit remoting, and essentially imports all of the functionality that exists in $Session into the local session (see figure 3). It creates a temporary PowerShell module that contains all of the Exchange Online commands you can use.
Notice the module name in figure 3. This is a temporary module name that contains all of the commands. I recommend documenting this so you can then explore the commands for Exchange Online. In my example, if I run Get-Command –Module tmp_lhg4ygs5.pgh, I will see all of the commands that are available to work with.
Again, run a Get command at first to ensure you're now able to pull information from the service. In this instance, I used Get-AcceptedDomain to ensure my domains show up (see figure 4) for Exchange Online in PowerShell.
Now that you can connect PowerShell to Office 365 and Exchange Online, explore what you can do. Try to correlate the actions in the graphical user interface with a PowerShell cmdlet. Use the Get-Command cmdlet to discover all of the commands you can use to manage both services. Once you get more comfortable using PowerShell for Office 365 and Exchange Online, you'll find that you'll be able to accomplish tasks much faster at the command line.
Copy files over a PowerShell remote session
Use PowerShell to add mailboxes to Office 365
Master Exchange with PowerShell scripting