Forum Discussion

Smudgers9's avatar
Smudgers9
Level 2
9 years ago

DQL Last Accessor Report

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")

No RepliesBe the first to reply