Determining retention policies for all users in O365

Question

I am running into incomplete data being returned when running the command, Get-mailbox -ResultSize Unlimited | select Name, RetentionPolicy | export-csv c:\ncs\retention-365.csv -not.

I am running this in Exchange Online Powershell to get retention policies assigned to all users

I have run the command multiple times but get different results each time. We have about 16k users in O365 and I am only getting results for 6600. Subsequent runs of the command give me results of 4500, 3800.

What am I missing?

Answer 1

It's likely that your PowerShell session is timing out. Try the new REST-based cmdlets, which should be more robust: https://learn.microsoft.com/en-us/powershell/exchange/exchange-online-powershell-v2?view=exchange-ps

Get-EXOMailbox -ResultSize Unlimited -Properties RetentionPolicy | select Name, RetentionPolicy   

You can also try running it in smaller batches, by filtering the users say per department, etc. Or simply try from a different machine/network, 16k should take just few minutes to return.