Understanding KB_Use Table

Wendell Hankins
Giga Contributor

I wanted to make sure I understand this correctly Used is when they attached article to a particular incident record correct?

Views mean is when it is populated from the short description field so if 4 articles populate that means that user would have 4 views per that incident record. If they change the short description and 7 articles populate they would have 11 views. 

Or do they have to open a Article for it to count as a view.

If I reading our last month report right for Used it says false=8,267 & true=1,526 

That means 8,267 articles were viewed but not attached out of that 1,526 were attached as solutions is that correct?

What is the column Total Views is that the total amount of times that article was viewed within a time span?

Is their a easy way to Pull incident tickets with the articles that are being attached with each ticket?

7 REPLIES 7

is their a table that tells you which cases did not get a KB attached?

No. There is no such table. You may need to export them into an excel and do a vlookup to find out the cases, not mapped to knowledge.

 

Also is their a easy way to see all the report tables in ServiceNow?

There is no simple way. You need to know about servicenow administration.

What I did is, opened the Tables and searched for all the tables that has kb word. Then found this table and opened it. And I was able to see the record I associated. So you need to do some research to find out.


Please mark this response as correct or helpful if it assisted you with your question.

Does anyone have an update on this? We are trying to produce link rate and want to add the field for knowledge found/not found on the Incident. It is too complicated without it being on the Incident table. Does anyone know if this might be planned for next release or has anyone done something like this?

Tristan DeMoss
Kilo Contributor

Does anyone know what columns m2m_kb_task and KB_Use share to run the Vlookup from?