Reporting monthly knowledge base article usage

[jctalk]

Hi,

We are looking to report on the number of knowledge base article use's by our users on self service. We have a knowledge base specifically for these users, but looking at the KB_KNOWLEDGE table I see only 'use count' and 'view count', I can't see a way to specify a specific month period to only get the count of use's in say October.

I've read an old post on here suggesting that the counts are on a rolling 30 days by default. Is this correct? If it is, is there any other way of achieving the above?

We don't have Performance Analytics.

Many thanks

[jctalk]

Hi Sarup,

I will check out the kb_use table. Thank you.

For my information and clarification, can you confirm if 'Use count' & 'View count' on the kb_knowledge table is a 30 day rolling calculation, or is it the SUM total of all uses and views respectively?

Many thanks

[Sarup Paul]

Yes, the View count rolls. The day count is configurable.

Number of days (integer, default 30) used when summing article views. Views older than this are not considered when sorting articles based on view count. 0 means consider all views. (glide.knowman.view_age.days)

Enter a number of days to consider when calculating view count. This is used only when the Knowledge section sort fieldproperty is set to View count. Enter 0 to have ServiceNowServiceNow consider all views, regardless of date.