How to know the Creation Date of User's Archive.

[Aju]

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 :


 

* Please refer to the  original forum thread https://www-secure.symantec.com/connect/forums/list-ev-powershell-commands for a complete scenario of when to use this information.
 

[Liam_Finn1]

Nicely Detailed

[JesusWept3]

nice, remember though that this date doesn't necessarily reflect when a user is enabled for archiving, only when the users archive was created

[Rob_Wilcox1]

Good information, thanks for sharing.

[SameerV]

Good technical stuff