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

Ok I think I understand now. Like what is the trigger for the "true." Let me see what I can find out! 🙂 

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. 

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 🙂

I reached out to my contact and will let you know what he says or when I hear back! 🙂 

Saurabh Gupta
Kilo Patron
Kilo Patron

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