cancel
Showing results for 
Search instead for 
Did you mean: 

Discovery Accelerator 11 - capture cases view to Excel/CSV

Ali_G
Level 4
Employee

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.

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

it's all in the DA database. check out dbo.tblCase for starters

View solution in original post

3 REPLIES 3

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

it's all in the DA database. check out dbo.tblCase for starters

Ali_G
Level 4
Employee

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

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

you're welcome. dont forget to mark the post as solved