Forum Discussion

Always_Somethin's avatar
Always_Somethin
Level 3
9 years ago

Enterprise Vault report for item age.

Hi Everyone There are many canned Data Analysis reports on space Usage, Storage, and vaults but I need reports on archived item age and count. We have Expiry turned off and want to turn it on. ...
Enterprise Vault
Information Governance
Reporting
Tip-How to
Windows Server (2003-2008)
  • WiTSend's avatar
    WiTSend
    9 years ago

    Try using this query, you will need to make some adjustments:

    Created date, size, etc...

    Dont forget to change EVMailboxVS01 to your relevent Vault Store Database name

    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,

    EVMailboxVS01..ArchivePoint AS VS1

     

    WHERE

    EME.DefaultVaultID = VS1.ArchivePointID AND

    EME.MbxArchivingState = 1 AND

    EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity

     

    If you have more than one Vaul Store you will need to join them with UNION and change EVMailboxVS02 to your relevent Vault Store Database name

    UNION

     

    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,

    EVMailboxVS02..ArchivePoint AS VS1

     

    WHERE

    EME.DefaultVaultID = VS1.ArchivePointID AND

    EME.MbxArchivingState = 1 AND

    EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity

WiTSend's avatar
WiTSend
Level 6
9 years ago

Try using this query, you will need to make some adjustments:

Created date, size, etc...

Dont forget to change EVMailboxVS01 to your relevent Vault Store Database name

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,

EVMailboxVS01..ArchivePoint AS VS1

 

WHERE

EME.DefaultVaultID = VS1.ArchivePointID AND

EME.MbxArchivingState = 1 AND

EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity

 

If you have more than one Vaul Store you will need to join them with UNION and change EVMailboxVS02 to your relevent Vault Store Database name

UNION

 

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,

EVMailboxVS02..ArchivePoint AS VS1

 

WHERE

EME.DefaultVaultID = VS1.ArchivePointID AND

EME.MbxArchivingState = 1 AND

EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity