GertjanA
6 years agoModerator
Discovery Accelerator - find who was in a search
Hello all,
I need to set Legal hold on case where specific people were targeted. As I have 100's of cases, and no overview which case is for who, can I somehow get the information from SQL?
I am looking for a query which would return Case-ID, and the content of the To/From search field (i.e. the Search criteria)
Is that possible?
Does anyone have such a query?
Much obliged!
Found it (more or less). Run against Customer Database.
SELECT [SearchID]
,[CaseID]
,[Name]
,[Description]
,[NativeQuery]
,[NativeLegacyQuery]FROM tblIntSearches
YOu can then use the CaseId to find the case name:
Select CaseId, Name from tblcase where caseid = xx