SQL Query for Scheduled Search Result

[Scott__Hastings]

Does anyone have a SQL Query that will return the results of each day's search. Name, Dept, Hits.Sampled, Duplicates?

Thanks!!

[EV_Ajay · Accepted solution]

Hi Scott,

Please run following SQL query against CA Customer Database in SQL.

Select tis.Name,tc.Name AS 'Dept',tis.NumHits AS 'Hits',tis.SampleSize As '% sample', tis.NumDuplicates AS 'Duplicates',tis.RunDate,tis.Type

From tblIntSearches tis

Inner Join tblCase AS tc

ON tis.CaseID=tc.CaseID

Note : TYPEs

110	Immediate
111	Application Standard
112	Schedule
113	Schedule run