cancel
Showing results for 
Search instead for 
Did you mean: 

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

dAncer
Level 3
Partner Accredited Certified
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 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
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 3

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified
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

RahulG
Level 6
Employee
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......

JesusWept3
Level 6
Partner Accredited Certified
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