Which archives/mailboxes are associated to which storage and index service?
- 14 years ago
This query may suit your needs more, its a beast though, so my apologies
SELECT R.VaultEntryID "VaultID", A.ArchiveName "Archive Name",
EME.LegacyMbxDN "Legacy DN", EME.MbxNTDomain "Domain", EME.MbxSendLimit "Send Limit",
EME.MbxSize "Mailbox Size", EME.LastModified "Last Modified", PTG.DisplayName "Provisioning Group",
PE.poName "Archiving Policy", ESE.ExchangeComputer "Exchange Server", T.Name "Task Name",
CE.ComputerName "Vault Store Server", VSE.VaultStoreName "Vault Store", (IRP.IndexRootPath + '\'+ IV.FolderName) "Index Folder",
IV.IndexedItems "Indexed Items", IV.OldestItemDateUTC "Oldest Item (Sent)", IV.YoungestItemDateUTC "Newest Item (Sent)",
IV.OldestArchivedDateUTC "Oldest Item (Archived)", IV.YoungestArchivedDateUTC "Newest Item (Archived)", IV.FailedItems "Failed Items"FROM EnterpriseVaultDirectory.dbo.Archive A,
EnterpriseVaultDirectory.dbo.Root R,
EnterpriseVaultDirectory.dbo.ExchangeMailboxStore EMS,
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME,
EnterpriseVaultDirectory.dbo.PolicyTargetGroup PTG,
EnterpriseVaultDirectory.dbo.PolicyEntry PE,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry ESE,
EnterpriseVaultDirectory.dbo.VaultStoreEntry VSE,
EnterpriseVaultDirectory.dbo.StorageServiceEntry SSE,
EnterpriseVaultDirectory.dbo.ComputerEntry CE,
EnterpriseVaultDirectory.dbo.ArchivingRetrievalTask ART,
EnterpriseVaultDirectory.dbo.Task T,
EnterpriseVaultDirectory.dbo.IndexRootPathEntry IRP,
EnterpriseVaultDirectory.dbo.IndexVolume IVWHERE A.RootIdentity = R.RootIdentity
AND R.VaultEntryID = EME.DefaultVaultID
AND EME.PolicyEntryID = PE.poPolicyEntryID
AND EME.PolicyTargetGroupEntryID = PTG.PolicyTargetGroupEntryID
AND EME.MbxStoreIdentity = EMS.MbxStoreIdentity
AND EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
AND ESE.ExchangeServerEntryID = ART.ExchangeServerEntryId
AND ART.TaskEntryID = T.TaskEntryID
AND VSE.StorageServiceEntryId = SSE.ServiceEntryId
AND SSE.ComputerEntryID = CE.ComputerEntryID
AND A.VaultStoreEntryID = VSE.VaultStoreEntryID
AND R.RootIdentity = IV.RootIdentity
AND IV.IndexRootPathEntryID = IRP.IndexRootPathEntryID