Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Archiving and eDiscovery Community Blog
Showing posts tagged with Database
Showing posts in English
Wayne Humphrey | 15 Dec 2009 | 1 comment

So here is a SQL script to work out the hourly archiving rate, for the past 24 hours .

You will need to define all the Vault Stores in this query.

USE VaultStore01
SELECT Min(archiveddate) AS ArchivedDate,
 "Hourly Rate for Americas Vault Store 04" = count (*),
 "Av Size" = sum (itemsize)/count (*)
FROM Saveset s
 
WHERE archiveddate > dateadd(hh, -24, getUTCdate ())
GROUP BY LEFT (convert (varchar, s.archiveddate,20),14)
ORDER BY LEFT (convert (varchar, s.archiveddate,20),14) DESC
 
USE VaultStore02
SELECT Min(archiveddate) AS ArchivedDate,
"Hourly Rate for  APJ Vault Store 02" = count (*),
"Av Size" = sum (itemsize)/count (*)
FROM Saveset s

 

Wayne Humphrey | 13 Dec 2009 | 1 comment
This SQL Script will get all List of all Archives and dispaly the following:
  • Mailbox Name
  • 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,
EVVaultStore01..ArchivePoint AS VS1
 
WHERE 
EME.DefaultVaultID...
Wayne Humphrey | 08 Dec 2009 | 0 comments
Often the question of what is the different states of MbxArchivingState and MbxExchangeState in the ExchangeMailboxEntry table.

The Archiving State translates as follows:

0 = Not Enabled
1 = Enabled
2 = Disabled
3 = Re-Link

To view the Archiving State you can use the following:

SELECT count(MbxArchivingState) as '# Mailboxes',
MbxArchivingState as 'Archiving State'
FROM ExchangeMailboxEntry
GROUP BY MbxArchivingState

The Exchange State translates as follows: 
 

0 = Normal
1 = Hidden
2 = Deleted

To view the Exchange State you can use the following:

SELECT count(MbxExchangeState) as '# Mailboxes',
MbxExchangeState as 'Exchange State'
FROM ExchangeMailboxEntry
GROUP BY MbxExchangeState