Using PowerShell for view and export information about mailbox migration to Office 365 | Part 4#5

The current article is the continuation of the previous article, in which we review the various PowerShell cmdlets that we can use for viewing, and export information about the process of Exchange mailbox migration process.

The “mailbox migration” PowerShell commands that we review in this article are:

• Get-MigrationStatistics
• Get-MigrationUser
• Get-MigrationUserStatistics

In addition, we review the PowerShell commands that we can use for getting information about on-Premises environment.

1. Migration Statistics | Get-MigrationStatistics

Get + Export Information | Migration Statistics

The PowerShell command Get-MigrationStatistics, provide us information about the migration process using properties such as – Synced Count, Total Count and more.

Get information about Migration Statistics

PowerShell command syntax

Get-MigrationStatistics -Diagnostic

PowerShell console output example

PS C:\> Get-MigrationStatistics -Diagnostic

MigrationType       TotalCount FailedCount SyncedCount
-------------       ---------- ----------- -----------
ExchangeRemoteMove  4          0           0

Get + Export information about Migration Statistics | Example

Get-MigrationStatistics -Diagnostic |Format-List | Out-File c:\temp\"Get-MigrationStatistics -Diagnostic.txt" -Encoding UTF8

Migration Users

Get + Export Information | Migration Users

As mentioned, each Exchange mailbox must have a “user account” that is associated with the mailbox (mailbox owner).

The PowerShell command that we use for getting information about the user account that is “attached” to the mailbox that we migrate are:

• Get-MigrationUser
• Get-MigrationUserStatistics

2. Get migration user information | Get-MigrationUser

The PowerShell command Get-MigrationUser, display information about the user account properties that is associated with the Exchange mailbox that we migrate + high level information about the mailbox migrated content.

Get information about specific “Migration User”

PowerShell command syntax

Get-MigrationUser <Migrated user account>

PowerShell console output example

PS C:\> Get-MigrationUser onpremmbx-01@o365info.com

Identity                   Batch                      Status     LastSyncTime 
--------                   -----                      ------     ------------ 
onpremmbx-01@o365info.com  Eyal Migration batch -001  Completed  2/23/2017 10:47:28 AM

Export information about specific “Migration User” | TXT File

Get-MigrationUser onpremmbx-01@o365info.com |Format-List | Out-File c:\temp\"Get-MigrationUser - onpremmbx-01@o365info.com.txt" -Encoding UTF8

Export information about ALL “migration users” | TXT File

To get information about ALL “migration users” + export the information to text file, we can use the PowerShell command example.

PowerShell command example:

Get-MigrationUser | Format-List | Out-File c:\temp\"Get-MigrationUser.txt" -Encoding UTF8

Export information about ALL “migration users” | View specific properties | TXT File

If we want to “refine” the result and view the most relevant information we can use the following PowerShell syntax.

PowerShell command example:

Get-MigrationUser | Select Identity,RecipientType,SkippedItemCount,SyncedItemCount,Status,BatchId,LastSuccessfulSyncTime | Out-File c:\temp\"Get-MigrationUser.txt" -Encoding UTF8

3. Get migration user Statistics information | Get-MigrationUserStatistics

The PowerShell command Get-MigrationUserStatistics will get us additional information about “migrated user” that is associated with the mailbox that we migrate + more detailed information about the mailbox content meaning, mail items that are migrated.

Get information about specific “Migration User Statistics”

PowerShell command syntax

Get-MigrationUserStatistics <Migrated user account>

PowerShell console output example

PS C:\> Get-MigrationUserStatistics onpremmbx-01@o365info.com

Identity                   Batch                      Status     Items Synced  Items Skipped 
--------                   -----                      ------     ------------  ------------- 
onpremmbx-01@o365info.com  Eyal Migration batch -001  Completed  4             0

Export information about specific “Migration User Statistics” | TXT File

Get-MigrationUserStatistics onpremmbx-01@o365info.com | Format-List | Out-File c:\temp\"Get-MigrationUser.txt" -Encoding UTF8

Export information about specific “Migration User Statistics” + more detailed information | TXT File

In this scenario, we add the following additional parameters: IncludeReport , Diagnostic and IncludeSkippedItems that could help us to get more details.

PowerShell command example:

Get-MigrationUserStatistics onpremmbx-01@o365info.com -IncludeReport -Diagnostic -IncludeSkippedItems | Format-List | Out-File c:\temp\"Get-MigrationUser.txt" -Encoding UTF8

Export “Migration User Statistics” All Migration User + Detailed information | XML File

In this scenario, we get the most detailed Statistics information about ALL the existing “Migration Users” and export the information to XML file.

PowerShell command example:

Get-MigrationUserStatistics -IncludeReport -Diagnostic -IncludeSkippedItems| Export-CliXml c:\temp\"Get-MigrationUserStatistics -IncludeReport -Diagnostic.xml" -Encoding UTF8

5. On-Premise infrastructure information

The current article series is dedicated to the Office 365 and Exchange Online environment but in some troubleshooting scenario, we will need to get more information about the “on-Premises infrastructure”.

For example, we get migration errors that are related to a specific user, or a specific mailbox.
We suspect that the issue can be realities to a problem with the On-Premise Active Directory user account or, to a “problematic Exchange On-Premises mailbox”.

On-Premise Active Directory

Export information about On-Premise Active Directory user

To get information about specific Active Directory user account + export the information to TXT file we can use the following PowerShell command.

PowerShell command example:

Get-Aduser onpremmbx-01@o365info.com -Properties * | Format-List | Out-File c:\temp\npremmbx-01@o365info.com -Active Directory user.TXT

Exchange on-Premises infrastructure

To get information about specific Exchange on-Premises mailbox we can use the following two PowerShell commands:

• Get-Mailbox
• Get-MailboxStatistics

Get-Mailbox PowerShell command

To get information about specific Exchange on-Premises mailbox + export the information to TXT file, we can use the following syntax:

Export information about Exchange on-Premises mailbox

PowerShell command example:

Get-Mailbox onpremmbx-01@o365info.com | Format-List | Out-File c:\temp\onpremmbx-01@o365info.com-Get-Mailbox on-Premises.txt

Get-MailboxStatistics PowerShell command

The PowerShell command Get-MailboxStatistics, can help us to get a very detailed information about Exchange mailbox “structure”, that include information about each mailbox folder, the number of mail items in each folder and much more.

Export information about Exchange on-Premises mailbox tatistics | TXT file

Get-MailboxStatistics onpremmbx-01@o365info.com | Format-List | Out-File c:\temp\"onpremmbx-01@o365info.com" -Get-MailboxStatistics on-Premises.txt

Get-MailboxStatistics onpremmbx-01@o365info.com –IncludeMoveHistory| Export-CSV c:\temp\"onpremmbx-01@o365info.com -Get-MailboxStatistics on-Premises - IncludeMoveHistory.CSV" –NoTypeInformation -Encoding utf8

Download Mail Migration PowerShell script

The next article in the current article series

How to use the export mailbox migration information and troubleshooting PowerShell script | Part 5#5