Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Unique article views

SNOWPie
Tera Expert

Is there a way to get the unique view count of a article? 

9 REPLIES 9

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SNOWPie 

 

I dont want to copy any one answer, so posting the link

 

https://www.servicenow.com/community/knowledge-managers/how-do-i-run-a-report-to-see-how-many-unique...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

RaghavSh
Mega Patron

The views are stored in "kb_use" table.

You can query or use group by to get unique records.


Please mark the answer correct/helpful accordingly.


Raghav
MVP 2023
LinkedIn

@SNOWPie did this work for you?


Raghav
MVP 2023
LinkedIn

CelesteTroxell
Tera Contributor

Did you find a way to do this? I read the responses below and if I'm understanding what you're asking, these responses don't help. I was also looking for a way to have a unique count. Meaning if the article was viewed 30 times, but the same user viewed it 10 of those times - I want to see the count of 20 (so that user that viewed it 10 times is only counted as ONE).  Is this what you're looking for?