Please enter search query.
Search <product_name> all support & community content...
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.