Column/Data explanations of Knowledge Searches Log (ts_query_kb)

Lesley W · ‎07-19-2021

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.

jaimehonaker · ‎09-16-2021

@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:

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? 🙂

View solution in original post

Barry_W · ‎09-24-2021

Apologies if this question merits a new thread but it strikes me as closely related to this topic.

My question is, what defines which searches appear in the ts_query_kb table?

Are those which appear in ts_query_kb only those where a 'knowledge' record has appeared in the results?

I've done some analysis on the sys_search_event table also, and there seems to be some crossover in terms of the data collected. I think sys_search_event collects data from the service portal only though.

jaimehonaker · ‎09-24-2021

@Barry let me see what I can find out! 🙂

jaimehonaker · ‎10-22-2021

Hey there Barry! Received this reply from my SME -

Let me know if that's what you were looking for! Thank you!

Krunal2 · ‎09-20-2022

Hi,

This is really helpful post, thank you for posting the detail explanation.

Could you please also confirm if there is any data rotation applied to the table ts_query_kb ? As we are only seeing last 1 year of data in that table. Though we have checked table rotation, archival rules and scheduled job but did not find any clue on how is maintenance being done on this table.

Thanks

Krunal Thanki

Krunal2 · ‎09-20-2022

Please disregard my query, I found it. It defined under Instance scan -> Table Cleanup to keep only data for 365 days.

Thanks

Krunal Thanki