05-06-2010 10:27 PM
Solved! Go to Solution.
05-07-2010 12:23 AM
I have posted many SQL scripts that get stats, check out here and on http://www.evdiscuss.net/
This SQL Script will get all List of all Archives and dispaly the following:
SELECT
LEFT(MbxDisplayName,20) 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,
EVVaultStore01..ArchivePoint AS VS1
WHERE
EME.DefaultVaultID = VS1.ArchivePointID AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
05-07-2010 12:23 AM
I have posted many SQL scripts that get stats, check out here and on http://www.evdiscuss.net/
This SQL Script will get all List of all Archives and dispaly the following:
SELECT
LEFT(MbxDisplayName,20) 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,
EVVaultStore01..ArchivePoint AS VS1
WHERE
EME.DefaultVaultID = VS1.ArchivePointID AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
05-07-2010 02:47 AM