cancel
Showing results for 
Search instead for 
Did you mean: 

SIS reduction summary report

deepak_jindal12
Level 3

Hi,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

3 REPLIES 3

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Do you have EV Reporting installed?

Another question, does HCP do its own SIS?

deepak_jindal12
Level 3

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"

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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