DataConsistencyScore Investigate (skipped items need approval)

The migration found some data loss and will not complete until an admin reviews and approves the skipped items.

Why it happens

Exchange Online grades each migration with a Data Consistency Score of Perfect, Good, Investigate or Poor. Investigate means a small amount of noticeable data loss was found. For migration types with a finalisation phase, such as hybrid moves and Google Workspace onboarding, an Investigate or Poor score needs approval before the move can complete. A batch takes the worst score of any user in it.

How to fix it

1. 1

   Step 1

   List the skipped items for the user and review what will be left behind.

2. 2

   Step 2

   If the loss is acceptable, approve skipped items on the user or the whole batch. For move requests created directly, set SkippedItemApprovalTime.

3. 3

   Step 3

   Approving a batch completes users scored Perfect, Good or Investigate. Users scored Poor cannot be forced through; contact Microsoft Support for those.

$userStats = Get-MigrationUserStatistics -Identity user@contoso.com -IncludeSkippedItems
$userStats.SkippedItems | Format-Table -AutoSize Subject, Sender, DateSent, ScoringClassifications
Set-MigrationUser -Identity user@contoso.com -ApproveSkippedItems
Set-MoveRequest -Identity user@contoso.com -SkippedItemApprovalTime $([DateTime]::UtcNow)

Source

Full guide: How to migrate from Exchange Server to Exchange Online →