Report on Most Used Article This Year?

[feenix]

I've been tasked with creating a report to find the most used Knowledge Base article this year.  Looking at the kb_use table, I don't see a way to filter views for this year only.  Can someone provide some guidance?

[Tony Chatfield1]

Hi,

kb_knowledge 'sys_view_count'  seems to give you a total count, but not by year

https://docs.servicenow.com/bundle/london-servicenow-platform/page/product/knowledge-management/concept/article-versioning-feedback.html

Perhaps you just need to run a report that aggregates the entries in kb_use for a date range?

Regards Tony

[Allen Andreas · Accepted solution]

Should use the kb_use table as you've done.

Then choose created - on - this year, then group by article. 

When a user views a KB it creates an entry on this page so do that and voila, you'll see which article was viewed the most. You could also look in to ensuring it only counts by each user so that if one person went 5 times...it doesn't count overall, but I think that's more edge case and unnecessary.

Try this:

Then just look for article with the highest number.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Knowledge Ninja]

How does one make a nice user-friendly version of this report?

These are our most used Articles:

Title/Use Count

Send an Email 3,000

Answer the Phone 2,500

Also in this view the Sorting does not seem to work.