Forum Discussion
CConsult
7 years agoModerator
Hi, try this one:
you need to change Vaultstore DB accordingly.
You can also order by any other criteria.
This shows you what data consumes how much compressed uncompressed and shows SISPartcount.
I normally export to csv to play arround with it.
SELECT TOP *
FROM [EnterpriseVaultDirectory].[dbo].[FileSpecification] INNER JOIN [VaultStoreDB].[dbo].[FileTypeSummary]
ON (FileSpecification.FileTypeIdentity =FileTypeSummary.Type)
ORDER BY LogicalCompressedSize desc
Related Content
- 3 months ago
- 11 years ago
- 12 years ago