How to get the deleted folder/Project audit report from dms_audt table if parent folder/project GUID is supplied?

Hello Everyone,

I am trying to get the deleted folder record entry for selected parent folder/project from the dms_audt table.

The dms_audt table just has the entry for the created folder/project information for the guid queried.

I can see the entry of the deleted folder by querying the deleted folder guid. But I do not know how it is connected to the dms_audit table entry?

Can anyone help me to find the deleted folder/project record in dms_audt table on its parent folder guid queried?

Also the properties->Audit trail for the folder/project selection shows the deleted folder audit entry. So it is being logged somewhere.

Thank you.