KA reporting- is there a way to report on the exact time/date an article is viewed?

[v_sopha]

I'm trying to pull reports on the following;

1. How many times an article has been viewed?

2. Who viewed the article and when (date) and time the article was view by each person.

I'm able to pull the data on who viewed the article but I can't seem to find the field (if it even exist) on when that individual viewed the article?

Can somehow point me to where I can get this data?

[Uncle Rob · Accepted solution]

The knowledge table (kb_knowledge) has a field called view count.   Each of those views is stored as an individual record in the kb_use table.

There's property that dictates how old a view has to be before it isn't counted any more.   By default, any view that happened over 30 days ago is not counted.

Knowledge -> Properties -> "Number of days (integer, default 30) used when summing article views. Views older than this are not considered when sorting articles based on view count. 0 means consider all views."

To know exactly when an article was viewed by a specific user, you'll be looking at the "created" field on the kb_use table.

[tim_harris]

So, your comment wasn't here when I posted mine or I would not have posted after you. I must not have refreshed. Anyways...

Thanks for the bit on the view count and the knowledge property. Somehow I overlooked that. It explains why my view counts on the kb_knowledge table were off.

[v_sopha]

Thanks, it worked!

[tim_harris]

Report on the "Knowledge Use" table. It tracks the date, user, article, and wether it was used or viewed.