Search results are stored in any table in service now ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 08:46 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 08:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 09:00 AM
Knowledge: ts_query_kb
Service Portal: sp_log
-> Filter this where type = search
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 09:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 10:02 AM
This should help for global
type in text_search.list in your left navigation bar