How to get the list of emails added to a retention policy in Purview?

Dmitriy Kolesnikov 11

We have created a few retention policies for Microsoft Purview. Each policy is applied to many specific mailboxes (100 mailboxes max). Is there a way to get the list of mailboxes added to each policy?

The Get-RetentionCompliancePolicy command shows policy properties, including the ExchangeLocation field (in truncated view {account1, account 2, ...}). How to get the list of all accounts from that attribute?

Ganesh Gurram 2,305 Reputation points Microsoft Vendor

2024-12-23T22:59:59.33+00:00
Hello @Dmitriy Kolesnikov

Thanks for the question and using MS Q&A platform.

To retrieve the list of mailboxes associated with each retention policy in Microsoft Purview, you can use PowerShell commands to extract and format the information from the Get-RetentionCompliancePolicy command. The ExchangeLocation field contains the mailboxes, but it may be truncated in the output.

Here are steps to Retrieve Full List of Mailboxes for a Retention Policy:

Open PowerShell - Make sure you have the necessary permissions, and the Exchange Online Management module installed.

Connect to Exchange Online - If you haven't already connected to your Exchange Online environment, you can do so with the following command:

Connect-ExchangeOnline -User PrincipalName <your-admin-username>

Retrieve Retention Policies - Use the Get-RetentionCompliancePolicy command to get the retention policies and their properties.

$policies = Get-RetentionCompliancePolicy

Extract Mailboxes - Loop through each policy and extract the ExchangeLocation field. You can use the -ExpandProperty parameter to get the full list of mailboxes.

powershellVerifyOpen In EditorRunCopy code Explain 1foreach ($policy in $policies) { 2 $policyName = $policy.Name 3 $mailboxes = $policy.ExchangeLocation -join ", " 4 Write-Output "Policy Name: $policyName" 5 Write-Output "Mailboxes: $mailboxes" 6 Write-Output "-----------------------------" 7}

Hope this helps. Do let us know if you any further queries.
Ganesh Gurram 2,305 Reputation points Microsoft Vendor

2024-12-24T16:38:50.2133333+00:00

@Dmitriy Kolesnikov - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ganesh Gurram 2,305 Reputation points Microsoft Vendor

2024-12-26T05:08:25.1333333+00:00

@Dmitriy Kolesnikov - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

Share via

How to get the list of emails added to a retention policy in Purview?

Your answer