Creating report with unique views count with knowledge articles?

fenderylo
Kilo Explorer

Hello, im new user of Servicenow. I need to make report kb articles view count. But i need to have unique view count. How to do it? 

7 REPLIES 7

Hi @Adam Stout ...

 

Would you kindly share or explain how can we trigger all logs of every kb viewed???

 

TIA

Hi @Adam Stout ....

kindly ignore my previous message.

 

Thanks

Sai Kumar B
Mega Sage
Mega Sage

Hi @fenderylo 

Check out the kb_use table. You should then be able to do a COUNT DISTINCT aggregate on either Article per user or Users per Article. Whichever way you're needing to slice that.

Please mark my answer as helpful/correct, if applicable.

Best regards,

Sai Kumar