Export a list of all DA 10 Cases

Export a list of all DA 10 Cases

Hi Trying to look for a simple SQL query that will provide Case name, Case number owner and its status etc from SQL.

 

Does anyone have such a simple SQL Query ?

 

3 Replies

Re: Export a list of all DA 10 Cases

This might require some custom reporting to be set up. Drop me an email I can link you to the right people

Re: Export a list of all DA 10 Cases

Are you looking for something like this?

SELECT tc.[Name] AS 'Case Name',
tc.CaseID AS 'Case Number',
tp.PrincipalName AS 'Owner'
FROM tblIntSearches tis
JOIN tblCase tc ON tc.CaseID = tis.CaseID
JOIN tblPrincipal tp ON tp.PrincipalID = tc.OwnerPrincipalID
GROUP BY tc.Name,tc.CaseID,tp.PrincipalName

For the best O365 Reporting Solution click here Radar-Reporting
Highlighted

Re: Export a list of all DA 10 Cases

This one I just added the Status of the case:

 

SELECT tc.[Name] AS 'CaseID',
tc.CaseID AS 'CaseNumber',
tc.statusid ' CaseStatusID',
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, tc.statusid, ts.name