02-21-2014 07:45 AM
Hi,
How can we retrieve SIS reduction summary report on EV 10.0.3 with HCP storage.
Solved! Go to Solution.
04-16-2014 03:02 PM
Sorry for the delay, you could use something like this:
Runs against the FingerPrint 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
02-21-2014 07:49 AM
Do you have EV Reporting installed?
Another question, does HCP do its own SIS?
02-21-2014 08:03 AM
No EV reporting is not installed, HCP does its own SIS but we are not using that funtionality we are doing it via Enterprise Vault.Current Sharing level is "Share within Group"
04-16-2014 03:02 PM
Sorry for the delay, you could use something like this:
Runs against the FingerPrint 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