Knowledge - which table can I find the view count on a knowledge article?

[SNhydrone]

Which table can I find the view count on a knowledge article? i need to run a report on views. Thanks!

[Community Alums]

Hi @SNhydrone ,

It's " kb_use".

[Harish KM]

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

[Pratiksha]

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: COUNT on the sys_id field (to count the number of views)

Regards,

Pratiksha

[AndersBGS]

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