Highlighted

SIS reduction summary report

Hi,

 

How can we retrieve SIS reduction summary report on EV 10.0.3 with HCP storage.

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Sorry for the delay, you

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

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post

3 Replies
Highlighted

Do you have EV Reporting

Do you have EV Reporting installed?

Another question, does HCP do its own SIS?

For the best O365 Reporting Solution click here Radar-Reporting

No EV reporting is not

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"

Highlighted
Accepted Solution!

Sorry for the delay, you

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

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post