Is there another way of finding out if a file ever existed in D2 aside from the query below? We cannot find a file that were supposedly present in D2 and we want to prove/validate if the file truly existed.
select * from dm_audittrail where owner_name='johndoe' AND time_stamp > DATE('01/01/2000','dd/MM/yyyy') AND time_stamp < DATE('01/01/2000','dd/MM/yyyy');
