Knowledge Base Article

Enterprise Vault useful SQL queries

I have worked some time on EV and due to encountering many issues which were hidden from day to day system checks we developed some interesting and useful SQL queries which when used can keep you bet...

Published 15 years ago

Version 1.0

Enterprise Vault

Information Governance

Level 5

15 years ago

Here's a good one.

** Description:    Return all vaults that have at least one failed item in them.
**
** Requirements:          Run against the EnterpriseVaultDirectory database

Select IndexRootPathEntryId, FolderName, FailedItems from IndexVolume
Where FailedItems > '0'
order by faileditems desc