Report on last view article

[ST9]

I wanted to fetch the last viewed article report, i'm using kb_use table but the table show multiple record i wanted to get the latest view data as highlighted

How do i get this?

[Mark Manders]

The KB use table will show you all usage for the articles, so there is no way of filtering out just the last record per article. If this, for some reason, is important to know, you could put a date/time field on the kb_knowledge table and update it with the created date/time on insert of a kb_use record.

[AndersBGS]

Hi @ST9 ,

Can you try to specify what it should be utilized for - what is the business requirement? As you know, last view will update multiple times for whenever a user is viewing a kb article. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards 
Anders

[Webbs78]

I've encountered a similar ask... stakeholders want to know which articles were last viewed over 1/2/3 months ago etc. They wish to do so to decide if some articles (despite not being past their Valid To date) are worth retiring because no one has looked at them for X number of months.

[Mark Manders]

Asking a different question on another question isn't the best way to get an answer and could also make the thread useless. It is always best to ask your own question.

The kb_view table also has an 'updated' field. If it's not updated in the last 3 months, then it has not been viewed. But it is a wrong requirement from the business. Some articles can contain highly specific information that is only used 3 or 4 times a year. Retiring shouldn't be done based on the number of views. It should be based on the if the content is still relevant/correct.
If you have an article outlining some steps to check on an application after Daylight Savings comes in again, you only have that once a year. Retiring can have huge complications, because nobody knows what to check anymore.