Check effective mailbox policy

[TimHudson]

Is it possible to check to see a specific mailbox's effective mailbox policy?  I have multiple mailbox policies who's targets are assigned by multiple provision groups.  The targets are AD OU based, so it's possible there's some overlap.  I have a user whose archiving far too frequently, and it seems as if she somehow has the wrong mailbox policy.  I'd just like to verify which policy EV has associated her mailbox with.  I'm running Enterprise Vault 8.0 SP4

Thanks!

[JesusWept3 · Accepted solution]

Through the VAC
1. Open the Vault Admin Console
2. Expand out Targets and right click "Exchange"
3. Click "Display Policies Assigned To Mailboxes"
4. Type in the name you want to check and keep all the exchange servers checked
5. Press Find and it will tell you the policy that particular users


Through SQL Server
Run the following query through SQL Enterprise Manager or Studio

USE EnterpriseVaultDirectory
SELECT EME.MbxDisplayName, PE.poName
FROM ExchangeMailboxEntry EME, PolicyEntry PE
WHERE EME.PolicyEntryID = PE.poPolicyEntryId
AND MbxDisplayName IN ('User A', 'User B')

[TimHudson]

Exactly what I needed!

[JesusWept3]

Actually this query may better help you

SELECT  EME.MbxDisplayName, PE.poName,
        PTG.DisplayName "Provisioning Group",
        PTM.DisplayName "Provisioning Member"
FROM    ExchangeMailboxEntry EME,
        PolicyEntry PE,
        PolicyTargetGroup PTG,
        PolicyTargetMember PTM
WHERE EME.PolicyEntryId = PE.poPolicyEntryId
      AND EME.PolicyTargetGroupEntryId = PTG.PolicyTargetGroupEntryId
      AND EME.PolicyTargetMemberEntryId = PTM.PolicyTargetMemberEntryId
      AND EME.MbxDisplayName IN ('User A', 'User B', 'User C')

[Rob_Wilcox1]

I was asked a while ago, and did a little video to demo it :

https://www-secure.symantec.com/connect/videos/secrets-vac