I was wondering if there is an option in DA client or a SQL query where we can export "Cases view" listing from Discovery Accelerator.
What we need is to export "Case Name, Date Created, Owner, Legal Hold state, Analytics Status, Items, Errors and Remaining items" fields for each case from the the DA database for cases both open and closed.
Thank You.
it's all in the DA database. check out dbo.tblCase for starters
it's all in the DA database. check out dbo.tblCase for starters
Thank you Andrew. I tried the following SQL query, which produced the results I was looking for:
SELECT TOP 1000 [CaseID]
,[Name] AS 'Case Name'
,[CreateDate] AS 'Date Created'
,pr.PrincipalName AS 'Owner Name'
,[LegalHoldState]
,[LegalHoldReason]
FROM [EVBADiscovery].[dbo].[tblCase] cs
INNER JOIN [EVBADiscovery].[dbo].[tblPrincipal] pr ON cs.OwnerPrincipalID = pr.PrincipalID
WHERE Type = 101 AND StatusID = 20 AND FolderType = 330
you're welcome. dont forget to mark the post as solved
