cancel
Showing results for 
Search instead for 
Did you mean: 

DQL Last Accessor Report

Smudgers9
Level 2

Hi,

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?

FROM Path

Get basename, absname, created_on, last_accessed, last_accessor.name, last_modifier.name

IF extension IN ("xlsm")

0 REPLIES 0