We have been able to create a report showing the number of views on a page within the Service Portal using the sp_log table, the user is now wanting to understand the users using this page, which departments, companies, teams etc they belong to. He would like to understand which area of users is using the page the most.
I can't see any way to drill down into the user data from the sp_log table where we are getting the number of views on a page from. It only holds a sessions ID.
I have also reviewed the User Experience analytics > UI analysis > pages and this shows the session details and the hashed user id but that is it.
Has anyone been able to create this type of report?
Surely it shouldn't be this hard.
