List of articles viewed by Knowledge Base (not the bare kb_use table)

[William Busby]

Is it possible to join the kb_use table to include the knowledge base in addition to the KB article? I'm being tasked to identify the articles 'Guest User' has accessed by article and knowledge base. Any assistance would be helpful.

[Swapna Abburi · Accepted solution]

@William Busby 

As Article field is a reference field on kb_use table, you can always dot-walk to the Knowledge base. No separate join is required.

[William Busby]

All I can say is, Doh!

[Community Alums]

Hey @William Busby 

Give this a go in a Database View:

Then you can adjust the columns to be what you are looking for:

~Nick