Views vs Use in kb_knowledge Table

Cari3
Tera Contributor

Can someone explain to me the difference in the View Count and the Use Count from the kb_knowledge table?

 

kb_knowledge View Count = views over the duration specified in the properties (usually last 30 days)

kb_use View Count = views over the life of the article (all versions)

 

But what is the Use Count from the kb_knowledge table?  See my list

 

 

3 ACCEPTED SOLUTIONS

AshishKM
Kilo Patron
Kilo Patron

Hi @Cari3 , 

The Use count of Knowledge (kb_knowledge ) reflect the count of other records where this KB has been attached, in other way, how many times this KB has been added to incident or other records.

You can test with one KB and attached this KB with INC, the use count will increment by 1.

 

 

-Thanks,

AshishKMishra 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

Samir_A
Mega Expert

If you are using HRSD, same is true for KB attached to HRC 

View solution in original post

Arnaldo
Tera Guru

Hi Cari 
Likely the answer is in this very old post that reports how the "view count" is somehow triggered by the Knowledge property glide.knowman.view_age.days and "use count" not.
 Solved: Re: How are knowledge article use count and view c... - ServiceNow Community
You can check by yourself,   comparing the total number to use count of an article from kb_use
and the value that is reported in the use count of kb_knowledge in the same article. 
They are the same.
The reason for having this value available in both tables could depends from different OOTB rights granted to 2 tables kb_use and kb_knowledge.
For what I know kb_use is accessible OOTB from admin, knowledge_admin, knowledge_manager only  

View solution in original post

6 REPLIES 6

Arnaldo
Tera Guru

Hi Cari 
Likely the answer is in this very old post that reports how the "view count" is somehow triggered by the Knowledge property glide.knowman.view_age.days and "use count" not.
 Solved: Re: How are knowledge article use count and view c... - ServiceNow Community
You can check by yourself,   comparing the total number to use count of an article from kb_use
and the value that is reported in the use count of kb_knowledge in the same article. 
They are the same.
The reason for having this value available in both tables could depends from different OOTB rights granted to 2 tables kb_use and kb_knowledge.
For what I know kb_use is accessible OOTB from admin, knowledge_admin, knowledge_manager only  

Cari3
Tera Contributor

How can I see where the article has been "used" or attached to an incident or HR case?