Log of all users that have accessed a particular ticket

[Mosh]

Hello

Is there a way we can obtain a log of users that have accessed a particular ticket? (where they haven't left a footprint on the timeline?).

Thanks

[Jim]

I've asked this one before and essentially there is no 'foot printing' built into this, the only way to view is if an action was taken sadly

[Mosh]

I thought this might be the case - thanks very much  for confirming Jim

[Gareth Cantrell]

You could report on the h_sys_pagevisit_log table which was introduced a few months back.

This gives you the path that was visited, the user who visited and the timestamp of the visit.

I use the following query in Database Direct to examine the table, but you could do something similar in a report:

SELECT * FROM h_sys_pagevisit_log
WHERE h_path LIKE '%servicemanager/request/view/%' 
OR h_path LIKE '%com.hornbill.servicemanager/request/%'

 

[Jim]

ooooh now that is interesting! I missed that 

[Mosh]

That's brilliant, thanks @Gareth Cantrell