How to identify the archives that have items on Legal Hold using a SQL query
Article ID: 100034248
Updated On:
Resolution
The following SQL query run against the Discovery Accelerator (DA) customer database will provide a list of archives on legal hold:
Note: If there are multiple DA customer databases, be sure to run this query against each one.
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.KVSVaultNameNote: If there are multiple DA customer databases, be sure to run this query against each one.
Issue/Introduction
How to identify the archives that have items on Legal Hold using a SQL query.
Was this article helpful?
Yes
No
Powered by
