Enterprise Vault - Identify Old Archives
Does anyone have an SQL query that provides the last access date of an archive? Alternativley, if that is not available, would you know how to Query the last time an item was added into a archive?
...
Forum Discussion
this script will give you a bunch of stats about your archives including the date the archive was last updated. just change <YourMbxVaultStoreDB> to the name of your mailbox vault store database
hope it helps!
SELECT
MbxDisplayName AS 'Mailbox',
ExchangeComputer AS 'Exchange Server',
MbxItemCount AS '#Items (Mailbox)',
VS1.ArchivedItems AS '#Items (Archive)',
MbxSize/1024 AS 'Mbx Size (MB)',
VS1.ArchivedItemsSize/1024 AS 'Archive Size(MB)',
(mbxsize+VS1.ArchivedItemsSize)/1024 AS 'Total Size(MB)',
VS1.CreatedDate AS 'Archive Created',
VS1.ModifiedDate AS 'Archive Updated',
MbxExchangeState AS 'Exchange State'
FROM
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE,
EnterpriseVaultDirectory.dbo.ExchangeMailboxStore AS EMS,
<YourMbxVaultStoreDB>.dbo.ArchivePoint AS VS1
WHERE
EME.DefaultVaultID = VS1.ArchivePointID AND
EME.MbxArchivingState = 1 AND
EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity
