How to identify the archives that have items on Legal Hold using a SQL query

Article: 100034248
Last Published: 2017-07-06
Ratings: 1 0
Product(s): Enterprise Vault

Problem

How to identify the archives that have items on Legal Hold using a SQL query.

Solution

The following SQL query run against the Discovery Accelerator (DA) customer database will provide a list of archives on legal hold:
Select distinct tv.KVSVaultName AS 'Archive Name'
,tc.[Name] AS 'Case Name'
, ts.Name AS 'Status'
, ts.StatusID
FROM tblIntDiscoveredItems tidi
JOIN tblCase tc ON tc.CaseID = tidi.CaseID
JOIN tblVaults tv ON tv.VaultID = tidi.VaultID
JOIN tblStatus ts ON ts.StatusID = tidi.LegalStatus
--Comment out next line to see status of all archives regardless of Legal Hold status
WHERE LegalStatus = 426
ORDER BY tv.KVSVaultName


Note: If there are multiple DA customer databases, be sure to run this query against each one.

Was this content helpful?