Need csv or SQL export of "research" view
I have need of a report that will show me the following information on an EV email search I've performed in DA:
Sender, recipient, destination, subject, date/time sent.
While I can display th...
Pretty sure what you are looking for can be pulled via a SQL query but I do not believe there would be a way to get this data from the DA Client directly.
You could try this:
SELECT D.CaseId, C.Name, D.Author, D.Recipient, D.Subject, D.MailDate
FROM tblIntDiscoveredItems D
INNER JOIN tblCase C on C.CaseID = D.CaseID
WHERE C.Name = 'Research'You can use this to get the Case Name, should be the same as it appears in the DA Client.
Select * from tblCase
