Knowledge - which table can I find the view count on a knowledge article?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2024 07:05 PM
Which table can I find the view count on a knowledge article? i need to run a report on views. Thanks!
- Labels:
-
Case and Knowledge Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2024 08:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2024 08:53 PM - edited ‎05-16-2024 08:58 PM
Hi @SNhydrone There are 2 ways where you can find the view count
1. Kb_knowledge table there is a field called view count which gives the total count viewed by all users
2. kb_use table . In this table you get information of user who viewed the article and it inserts a new record each time with article number and user who viewed when the article is viewed in the Portal.
Now based on your requirement you can do what is needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2024 08:53 PM
he view count for knowledge articles is typically tracked in the Knowledge Use table, which is named kb_use in the system. This table records each instance of a knowledge article being viewed, providing detailed data that can be used to generate reports on article views.
Example Report Configuration
- Table:
Knowledge Use [kb_use] - Type: Bar Chart
- Group By:
Knowledge [kb_knowledge] - Aggregation:
COUNTon thesys_idfield (to count the number of views)
Regards,
Pratiksha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2024 10:26 PM
Hi @SNhydrone ,
You can utilize the kb_use table.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders