cancel
Showing results for 
Search instead for 
Did you mean: 

EV Discovery Accelerator SQL Query

Nickcru
Level 2

Hi All

I'm trying to run a SQL query to get a List of all Cases created in DA.  But I need the following fields:

Case Name, Case Owner, Creation Date ,Case Status and Number of hits per case

I'm Not sure how to add the Case Owner and the number of hits to the query below,

SELECT tc.[Name] AS 'CaseID',
tc.CaseID AS 'CaseNumber',
ts.name 'CaseStatus',
tp.PrincipalName AS 'Owner'

FROM tblIntSearches tis
JOIN tblCase tc ON tc.CaseID = tis.CaseID
JOIN tblPrincipal tp ON tp.PrincipalID = tc.OwnerPrincipalID
JOIN tblStatus ts ON tc.StatusID = ts.StatusID
GROUP BY tc.Name,tc.CaseID,tp.PrincipalName, ts.name

if someone can assist or just point me in the right direction ....

Thanks

0 REPLIES 0