cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

How to find "orphaned" archives (with no mailboxes being archived from)

Recently I've got a question from one of our customers: are there any ways to find archives (in EV 8.0 SP4) which do not have associated mailboxes anymore? Sample: there was a user "A", who had a mailbox on Exchange server and this mailbox has been archiving by EV to appropriate archive for user's A. Later on, this user's A account has been removed from AD as well as Exchange Mailbox for user "A". However, EV doesn't remove the archive automatically. Again, the question is: are there any possibilities to rapidly find these "orphaned" archives? Many thanks in advance!
1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

This query should do the

This query should do the trick

USE EnterpriseVaultDirectory
SELECT A.ArchiveName, R.VaultEntryID, T.SID
FROM Archive A, Root R, Trustee T
WHERE A.RootIdentity = R.RootIdentity
  AND R.OwningTrusteeIdentity = T.TrusteeIdentity
  AND R.VaultEntryID NOT IN
      (SELECT EME.DefaultVaultID FROM ExchangeMailboxEntry EME, Root R WHERE R.VaultEntryID = EME.DefaultVaultID)
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

3 Replies
Highlighted

try

Hello dancer,

(ev75)
Open console
Goto archives\exchaneg mailbox, check Bill usage to
Most likely you will see 'Account unknown (\S-1-5 etc)
Those are archives that no longer have an account associated.

GJ
Regards. Gertjan
Highlighted

You can Run the vault store

You can Run the vault store summary report
refer the following document http://support.veritas.com/docs/273270
1 . Hight light the mailbox vault store --Press shift Ctl key and right on the mailbox vault store-select reporting
2. Select Vault Store Usage by Archive report.
3. Check the billing account . The archive for which the AD account is delete would show up as  s-1-5-21-4232325654......
Highlighted
Accepted Solution!

This query should do the

This query should do the trick

USE EnterpriseVaultDirectory
SELECT A.ArchiveName, R.VaultEntryID, T.SID
FROM Archive A, Root R, Trustee T
WHERE A.RootIdentity = R.RootIdentity
  AND R.OwningTrusteeIdentity = T.TrusteeIdentity
  AND R.VaultEntryID NOT IN
      (SELECT EME.DefaultVaultID FROM ExchangeMailboxEntry EME, Root R WHERE R.VaultEntryID = EME.DefaultVaultID)
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post