cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Accpeted Searches

Is there a way to see what the search crirteria was for an accepted search?

 

Thanks

2 Replies
Highlighted

Re: Accpeted Searches

Something like this would work, you would want to look in the NativeQuery, NativeLegacyQuery columns.

SELECT SearchID,

            CaseID,

            NumHits,

            PrincipalName AS ModifiedBy,

            tblIntSearches.Name AS SearchName,

            tblIntSearches.ModifiedDate AS DateModified,

            CreateDate,

            tblStatus.[Name] AS SearchType,

            CreationType.[Name] AS CreationType,

            SampleResultSize,

            NativeQuery,

            NativeLegacyQuery,

            XMLText

FROM tblIntSearches

      LEFT OUTER JOIN [tblPrincipal] ON tblIntSearches.[ModifiedByID] = tblPrincipal.[PrincipalID]

      INNER JOIN [tblStatus] ON tblIntSearches.[Type] = tblStatus.[StatusID]

      INNER JOIN [tblStatus] CreationType ON tblIntSearches.CreationType = CreationType.[StatusID]

WHERE tblIntSearches.[StatusID] = 858 AND PrincipalName IS NOT NULL

UNION ALL

SELECT  TypeID AS SearchID,

            tblAudit.CaseID,

            NumHits,

            PrincipalName AS ModifiedBy,

            tblIntSearches.Name AS SearchName,

            AuditDate AS DateModified,

            CreateDate,

            tblStatus.[Name] AS SearchType,

            CreationType.[Name] AS CreationType,

            SampleResultSize,

            NativeQuery,

            NativeLegacyQuery,

            XMLText

FROM tblIntSearches

      INNER JOIN tblAudit ON tblAudit.TypeID = tblintSearches.SearchID

            AND tblIntSearches.StatusID = 858

            AND tblAudit.AuditTypeID = 1052

      LEFT OUTER JOIN [tblPrincipal] ON tblIntSearches.[CreatedByID] = tblPrincipal.[PrincipalID]

      INNER JOIN [tblStatus] ON tblIntSearches.[Type] = tblStatus.[StatusID]

      INNER JOIN [tblStatus] CreationType ON tblIntSearches.CreationType = CreationType.[StatusID]

ORDER BY CreateDate DESC

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

Re: Accpeted Searches

From the DA console make sure you slect the tick box to list searches in review (can't remember exact terminoligy) and then you should see the accepted search. You can now double click the listed search and see the settings used.