- 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,197 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
08-12-2021 03:28 PM
Ok I think I understand now. Like what is the trigger for the "true." Let me see what I can find out! 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2021 07:32 AM
Hey there Lesley, I still don't have the answer but I know where to go to get it. 😉
I think what would actually help while I am doing that, is if you leave a feedback utilizing the thumbs up/down on this piece of product documentation: https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/knowledge-management/task/find-knowledge-search-source.html. If I am being totally honest, I think that you being a customer might be better for us getting an answer. I think this needs to have more explanations of fields.
In the meantime, I am reaching out to my knwoledge product manager to see what they have to say about it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2021 03:13 PM
Thank you so much for your efforts, Jaime.
I've marked the documentation as you mentioned and will see if I get a response/assistance 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2021 04:45 AM
I reached out to my contact and will let you know what he says or when I hear back! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2021 03:40 PM
Hi,
Below link might be helpful.
View knowledge logs | ServiceNow Docs
If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.
Regards,
Saurabh
Thanks and Regards,
Saurabh Gupta