Search results are stored in any table in service now ?

Gaurav Kumar15
Giga Guru

Hi All,

Is there any table where service now stores the search resulted from specific search.

e.g :- If User A searched for something in the search and let say, the Search result gave no results(0 results), so is there any table where that data gets stored.

Or is there any way of tracking that level of information ?

Thanks,

Gaurav Kumar

5 REPLIES 5

adilrathore
ServiceNow Employee
ServiceNow Employee

All the activity is present in the system logs and comprehensively under node logs. So you need to search information for all users in System Log and probably you will have user searches as well.


johansec
Tera Guru

Knowledge: ts_query_kb


Service Portal: sp_log


                  -> Filter this where type = search


Gaurav Kumar15
Giga Guru

Hi Corey,



Thanks for the info.
So these are different table which stores knowledge search, catalog search, portal search right ?
And also there is one "Global Searches" table -> ts_query, which does not have any   result field, so in global search i was not able to find the number of results.





Thanks,


Gaurav


johansec
Tera Guru

This should help for global



type in text_search.list in your left navigation bar