Can I add a location column to the View Log table?

[Coralyn Notting]

On the Knowledge > All application, we have the view count column limited to the views in the last 30 days, and we'd like to keep it that way. However, I'd like to answer questions like "What employees (based on region/ location) found this knowledge base article useful?" I was thinking we could pull in the user's location to the View Log (which show the historical views for a KBA across versions). Would it be possible to pull this information into the View Log? If not, can I create a report that pulls in the user locations and the historical views, not just the view count?

[BalaG]

Hi @Coralyn Notting   one way to do this would be to create a view that joins three tables -  kb_use table, with sys_user table, and finally with cmn_location.  You can then write any report you like, just as you would on a table.

Hope that helps

--

Bala Guthy

Please mark this as a solution / helpful as appropriate

[Maik Skoddow]

Hi @Coralyn Notting 

yes, this is possible:

To achieve the same:

1) Configure List Layout:

2) Then select user and the expanding option:

3) Select "Location" and move it to the right side, then save.

Maik

[Romina22]

Yes, you can enhance the View Log table by adding a location column to track user locations. To achieve this, consider integrating a feature that captures and records user locations during each view. Alternatively, you can create a custom report that combines user locations with historical views, providing a comprehensive overview of knowledge base article utilization based on regions or locations. This approach allows for more nuanced insights into the geographic distribution of article usefulness within your organization.