Get a Report of All Inactive Office 365 Mailbox Users

This PowerShell script will give you a report of all of your Office 365 mailbox users who haven’t logged in for any given number of days. Once you’ve saved the script to a .ps1 file on your workstation or server, you can run it with just the script name or you can include the number of days inactive as a command-line option. the command-line option is especially […]

Read Me 2 Comments

Migrating Distro Groups from Exchange to Office 365, part 4

In steps 4 and 5 of part one I wrote, 4. Delete on-premises groups. After verifying that I had all the data I needed to rebuild them in the cloud (or on-premises if necessary), I removed the original groups… 5. Rename and address online groups. I wrote a third PowerShell script (Address_DistroGroup.ps1) that renames the new online groups to the old on-premises group names and […]

Read Me Leave comment

Migrating Distro Groups from Exchange to Office 365, part 3

In step 2 of part 1, I created online versions of all my on-premises distribution groups: 2. Create groups in Exchange Online. I used the list I created in step 1 to create corresponding groups in Exchange Online, appending ” OL” to the name of each group to avoid conflicts. This is easy enough to do using a formula in Excel to create the PowerShell […]

Read Me Leave comment

Migrating Distro Groups from Exchange to Office 365, part 2

In part one (see here) I mentioned a PowerShell script (Export_DistroGroup.ps1) that I wrote to export certain settings of distribution groups in preparation for migrating them to Office 365. 1. Gather data. I exported a list of all distribution groups and their properties to a csv file. Then I wrote a PowerShell script (Export_DistroGroup.ps1) to export key details to multiple csv files for each group, […]

Read Me 3 Comments

Migrating Distribution Groups to Office 365, part 1

I am most of the way through a hybrid-mode migration from Exchange 2010 to Office 365. There are a few stages in a hybrid migration. During the process, your on-premises Active Directory database and Exchange directories are synced to the cloud so that mailboxes that have been migrated still appear in the on-premises directory for mailboxes that have not migrated and vice versa. Distribution groups […]

Read Me Leave comment

Convert a HashTable to an Array

Of course, this only works with a single column in the hashtable… Say you have a list of mailboxes in a hashtable, like this: $Mailboxes = Get-Mailboxes -OrganizationalUnit administration But for some reason (It doesn’t really matter why, does it? You just do.) you want a list of their User Principal Names in an array instead of the hashtable. You can do this like so: […]

Read Me Leave comment

Remove Broken ActiveSync Device Partnerships

A user has hit his maximum mobile device count on your Exchange server, but when you try to remove an unused device that hasn’t synced in over a year, you get this error: If you look at the details of the error in the wizard, you’ll notice that the ActiveSyncDevice ID includes the user’s OrganizationalUnit. If you check the user’s current OU, chances are very […]

Read Me Leave comment