Forum Discussion

GertjanA's avatar
GertjanA
Moderator
6 years ago
Solved

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

  • 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