Good day,
I update multiple files under one document and every month add a new report with a date, i then hide the files under the files section.
Recently i went to look at a previous file under the document and found one of the files are missing. There was no audit trail and i cannot find the specific months file. when i revert back to the distribution done and the transmittal it opens the latest report and not that specific one that is missing.
Is there a reason for this?
Thank you
Hi Dean,I believe you can check the audit_info_def table for additional details.If a file every added into the system and was deleted, you can check when it was deleted and who deleted from the same table.You just need to know the file name and/or file id.
Dear Manav,
Can you advise how to check the audit detail in the def_table for additional info?
Please run below command on your database:
select * from object_audit_info where object_id='File ID' and action_type ='4'
Note: You need run a query on Document_copies table to find out the File ID, if you know the file name or number.
Answer Verified By: Dean Stander