I am trying to run a report to find the last time a file was accessed and by who. The below DQL query works with all columns apart from the last_accessor.name and last_modifier.name. If I run it without these 2 columns it works fine, as soon as I add one of these then it returns zero results. Can you advise how I obtain the last accessor data using the DQL query below please?
Get basename, absname, created_on, last_accessed, last_accessor.name, last_modifier.name