Error in executing the SIS SQL script

[Dushan_Gomez]

Hi,

I got this error:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'view_storagereport_sharingtype'.

What should I change to make the script working again ?

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

[TonySterling]

Hi Dushan,

What version of EV?

You need to make sure you are running it against the Fingerprint database, not the Vault Store database.  It should be similar to the name of your Vault Store Group.

Regards,

[Dushan_Gomez]

Tony, I'm running on EV 8.0 SP4

[TonySterling · Accepted solution]

Then you should be able to run it against the Vault Store Group (aka, Fingerprint) database.

[Dushan_Gomez]

I have right click the database called EVVaultstore1 and then here's what I got:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'view_StorageReport_SharingType'.

[TonySterling]

I think that is just a vault store db.

Can you run this?

USE EnterpriseVaultDirectory

SELECT * FROM VaultStoreGroup

That should return the name of the fingerprint db.