11-05-2009 03:53 AM
Solved! Go to Solution.
11-05-2009 04:17 AM
----------------------------------------------------------------- -- Author: Wayne Humphrey -- Date: 19th May 2008 ------------- Notes ------------- -- Get all List of all Archives and dispaly the following: -- Mailbox -- Exchange Server -- Number of Items (Mailbox) -- Number of (Archive) -- Mailbox Size (MB) -- Archive Size (MB) -- Total Size (MB) -- Archive Created -- Archive Updated ----------------------------------------------------------------- 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, EVNAMEOFVAULTSTORE..ArchivePoint AS VS1 WHERE EME.DefaultVaultID = VS1.ArchivePointID AND EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity UNION same as above with EVNAMEOFOTHERVAULTSTORE..ArchivePoint AS VS2
--wayne
11-05-2009 04:17 AM
----------------------------------------------------------------- -- Author: Wayne Humphrey -- Date: 19th May 2008 ------------- Notes ------------- -- Get all List of all Archives and dispaly the following: -- Mailbox -- Exchange Server -- Number of Items (Mailbox) -- Number of (Archive) -- Mailbox Size (MB) -- Archive Size (MB) -- Total Size (MB) -- Archive Created -- Archive Updated ----------------------------------------------------------------- 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, EVNAMEOFVAULTSTORE..ArchivePoint AS VS1 WHERE EME.DefaultVaultID = VS1.ArchivePointID AND EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity UNION same as above with EVNAMEOFOTHERVAULTSTORE..ArchivePoint AS VS2
--wayne
11-05-2009 04:17 AM