'Use count' field in knowledge table Vs 'Used' field in kb_use table

[Sweta1012]

Hi everyone,

Can anyone let me the difference between 'Use count' field in 'kb_knowledge' table Vs 'Used' field in 'kb_use' table. I believe it gets updated whenever a knowledge article gets attached to any record like Incident.

However, when I am checking there is a difference between the count in both the fields present in knowledge and kb-use table respectively.

For e.g.: Even if the ' use count' field for any knowledge article is showing as 4 in knowledge table, the 'used' field is showing as false for that particular article. Hence I am a bit confused.

Can anyone help me with understanding, how both the fields are exactly getting updated in both these tables and why is there a difference both these fields in the respective tables?

[Pam Calvey]

I believe the default is Used in an incident in the last 365 days and viewed (not in an incident) in the last 30 days. I know it's confusing so I'll be watching what others say. 

And my trick to remember which is which is view/30 is 6 characters and use/365 is also 6 characters. 🙂

[Sweta1012]

@Pam Calvey Thanks a lot for your reply, can you please help me in knowing where its exactly defined that Used in an incident is only for the last 365 days?

[Arnaldo]

Maybe this Knowledge View Count and User Count - Support and Troubleshooting (servicenow.com) 
and this post used count in kb_knowledge is not matching with m2... - ServiceNow Community
helps 

[Karen Willis]

From my point of view (Incidents): 

Table:  Knowledge Use [Kb_use] 

• Used= false:  means not attached to an incident as being used to resolve the incident
• Used=true:  means attached to the incident resolution. 
• Viewed = true:  article was viewed and is unknown if the article assisted in the resolution.  Great if article was view as self-help, nor do we know if the article assisted a user prior to a call. 

Note:  The "Used" count will continue to calculate and the "View" count will reset every 30 days.    

The following posting may be helpful too:

Solved: Re: Views vs Use in kb_knowledge Table - ServiceNow Community