11-20-2014 02:47 PM
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.
Solved! Go to Solution.
11-20-2014 02:53 PM
it's all in the DA database. check out dbo.tblCase for starters
11-20-2014 02:53 PM
it's all in the DA database. check out dbo.tblCase for starters
11-26-2014 11:02 AM
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
11-30-2014 08:47 AM
you're welcome. dont forget to mark the post as solved