cancel
Showing results for 
Search instead for 
Did you mean: 
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

To see what I have been up to lately click here O365 Migration and Management

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?

To see what I have been up to lately click here O365 Migration and Management
Highlighted

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

To see what I have been up to lately click here O365 Migration and Management

View solution in original post