Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

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