Column/Data explanations of Knowledge Searches Log (ts_query_kb)

Lesley W
Mega Guru

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.

find_real_file.png

 

I can't believe how much trouble I'm having finding this information.

Thank you in advance.

1 ACCEPTED SOLUTION

jaimehonaker
ServiceNow Employee
ServiceNow Employee

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

View solution in original post

24 REPLIES 24

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! 

@Lesley a little more information - my SME got back to me on this and ended up submitting a Doc Task (an internal version of Doc Feedback) for the team to update the doc pages with a list of all column definitions. 🙂 

Oh, that's amazing. Thank you again, @jaimehonaker. I really appreciate it!

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?

 

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!