on 07-07-2010 03:27 AM
In situation where we need to know when the user enable for archiving. This information can be taken from SQL database by these SQL query.
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, EVVSMailboxstore_1..ArchivePoint AS VS1 WHERE EME.DefaultVaultID = VS1.ArchivePointID AND EME.MbxArchivingState = 1 AND EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
Note : Please replace "EVVSMailboxstore_1" with your relevant Vault Store Database name.
Please refer Figure 1.
Figure 1 :
The Output of this Query shows the "Mailbox Name, Exchange Server Name, Items (Mailbox), Items (Archive), Mbx Size (MB), Archive Size (MB), Total Size (MB), Archive Created, Archive Updated, Exchange State."
Please refer Figure 2.
Figure 2 :
nice, remember though that this date doesn't necessarily reflect when a user is enabled for archiving, only when the users archive was created
Good information, thanks for sharing.
Good technical stuff