- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2021 07:04 PM
Does anyone know where I can find an explanation of each column available in the Knowledge Search Log (ts_query_kb)?
I'm particularly interested in 'Final Search Term' at the moment - what does True/False mean? I tried testing by pressing 'enter'/'return' on a search and can't work out why it sometimes says True and sometimes says False.
I can't believe how much trouble I'm having finding this information.
Thank you in advance.
Solved! Go to Solution.
- Labels:
-
Knowledge Management
- 4,205 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2021 12:07 PM
The usual sequence in which a user searches is the following:
- Search “How do I setup demand insights”
- Don’t find relevant results
- Refine the search term and search “How do I setup Knowledge demand insights ServiceNow”
- Find relevant result, and end the session.
This will create two records in kb_use, one with “How do I setup demand insights” as the search term and another with “How do I setup Knowledge demand insights ServiceNow” as the search term. Final Search Term field is set to false for both records.
A job runs and updates the Final Search Term to true for the second record, because that was the last search the user performed in that session.
I think if you check the table now, for the earlier searches you performed, some of the records would have been updated to true.
Does that help? 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2021 06:03 AM
SOOO happy that was helpful! In the meantime, I'll see what we hear back on the rest of the list - eventually we will get it - between your Doc task and my questions. 😉 But for now, at least we got this one!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2021 09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-22-2021 02:57 PM
Oh, that's amazing. Thank you again,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 11:35 AM
I thought the kb_use table was only tracking whether or not knowledge was used/linked to a record, or if it was viewed. How is kb_use tied to searches?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2025 11:41 AM - edited 07-21-2025 11:41 AM
Hi Cavila,
kb_use table is for when something is just viewed, it literally just means the article was "used" by someone looking at it. The Knowledge Applied to Tasks [m2m_kb_task] is the table for when a Knowledge Article gets attached to an incident / record.
Regards,
Eoghan
🌟 Rising Star 2024
If you found my reply helpful, please consider clicking Helpful or Accept as Solution to assist others in the community!