cancel
Showing results for 
Search instead for 
Did you mean: 

EV Exchange & File Server reporting

mrDavid
Level 4

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

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

1 REPLY 1

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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