SQL query Discovery Accelerator
Hello,
I would need help with a SQL query that allows me to see all the searches performed in Discovery accelerator (case, folders, etc...) filter by date.
Thank you in advance for your help.
Forum Discussion
1 Reply
Does this work?
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
