Column/Data explanations of Knowledge Searches Log (ts_query_kb)

[Lesley W]

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.

[Lesley W]

Thanks, Saurabh. I've seen that but it doesn't explain the columns of the reports/logs.

[Saurabh Gupta]

PFA

[Lesley W]

Thank you, Saurabh. I don't have access to this as Knowledge Admin so this is a big help.

Does it have anything on the "Final Search Term"?

[jaimehonaker · Accepted solution]

@Lesley I am checking to see if I can get a list - but this is what I got from my SME around the final search term:

The usual sequence in which a user searches is the following:

1. Search “How do I setup demand insights”
2. Don’t find relevant results
3. Refine the search term and search “How do I setup Knowledge demand insights ServiceNow”
4. 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? 🙂 

[Lesley W]

Ohhh! That's excellent and makes sense!

This must be a rarely recent job that runs because I've only for 'True' Final Search Terms from May 2021.

Thats great! So that means I use the 'False' Final Search Terms to see keywords that might need to be added to meta data etc. and I assume this is what the AI Search uses to improve search results as well.

Thanks so much @jaimehonaker!