Forum Discussion

mrDavid's avatar
mrDavid
Level 4
11 years ago
Solved

EV Exchange & File Server reporting

I'm running EV9.0.3 to archive our Exchange and Windows File servers.  I'm looking for a report to show statistics about how much data EV is holds, and how much space we are saving

I can access monitoring-web-app, though this only shows health info.  Whats the best way to get this info?

thanks in advance

Enterprise Vault
Information Governance
Monitoring
Reporting
Windows Server (2003-2008)
  • TonySterling's avatar
    TonySterling
    11 years ago

    Do you have EV Reporting installed and configued?

    If yes, see the Vault Store Usage Summary and Single Instance Storage Reduction report.

    Vault Store Usage Summary report

    Article:HOWTO96338  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO96338

    Single Instance Storage Reduction Summary report

    Article:HOWTO96919  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO96919

     

    You can access the Usage.asp from a URL even without reporting.  Browse to http://evservername/enterprisevault/usage.asp.  This will show you the amount of space saved but archiving.  You can also use SQL to get Single Instance savings.

    Run this query against FingerPrint database i.e. VaultStoreGroup database

    SELECT VaultStoreIdentity, SharingLevel, IsNull(SUM(TotalLogicalSISParts),0) AS TotalArchivedItems, IsNull(SUM(TotalStoredSISParts),0) AS TotalSharableParts,

    IsNull(SUM(TotalLogicalOrignalSize),0) AS TotalOrignalSize,

    IsNull(SUM(TotalActualCompressedSize),0) AS TotalCompressedSize

    FROM view_StorageReport_SharingType

    GROUP BY VaultStoreIdentity, SharingLevel

    If you do not have reporting I would recommend installing, see this:

    Implementing Enterprise Vault Reporting

    Article:HOWTO97161  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO97161
  • TonySterling's avatar
    TonySterling
    Moderator
    11 years ago

    Do you have EV Reporting installed and configued?

    If yes, see the Vault Store Usage Summary and Single Instance Storage Reduction report.

    Vault Store Usage Summary report

    Article:HOWTO96338  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO96338

    Single Instance Storage Reduction Summary report

    Article:HOWTO96919  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO96919

     

    You can access the Usage.asp from a URL even without reporting.  Browse to http://evservername/enterprisevault/usage.asp.  This will show you the amount of space saved but archiving.  You can also use SQL to get Single Instance savings.

    Run this query against FingerPrint database i.e. VaultStoreGroup database

    SELECT VaultStoreIdentity, SharingLevel, IsNull(SUM(TotalLogicalSISParts),0) AS TotalArchivedItems, IsNull(SUM(TotalStoredSISParts),0) AS TotalSharableParts,

    IsNull(SUM(TotalLogicalOrignalSize),0) AS TotalOrignalSize,

    IsNull(SUM(TotalActualCompressedSize),0) AS TotalCompressedSize

    FROM view_StorageReport_SharingType

    GROUP BY VaultStoreIdentity, SharingLevel

    If you do not have reporting I would recommend installing, see this:

    Implementing Enterprise Vault Reporting

    Article:HOWTO97161  |  Created: 2014-05-07  |  Updated: 2014-05-07  |  Article URL http://www.symantec.com/docs/HOWTO97161