Knowledge Article View Report- but exclude the views from the author

[sam222]

Hello - ServiceNow Community! 

I received a request from a user at my org to generate a knowledge article view count report, but I need a way to exclude the view count of the article's author. 

The view counts of articles are inflated because the knowledge authors tend to view it significantly more times than the end-users. Our goal is to understand the viewing habits of our end-users only.

Hope you can guide me in the correct path. Thank you in advance! 

Sam

[Mark Manders]

You can create a report on the kb_use table. That will show you all views. If you create a condition of article.author is different from User, it should show you what you need

[sam222]

Unfortunately, my options doesn't show 'user' as one of the choices when using condition of article.author is different from. I have also tried user different from

[Mark Manders]

Weird. I have the same thing. I was checking on the list view and there you can add the condition easily. Apparently, on reports it doesn't work like this. Maybe add it as a module in the Knowledge Application so it can just be found as list 'report'.