DQL to list down the deleted documents and folder details

Hi,

We want to list down the list of documents and folders deleted from the Documentum repository. Is there any way we can get such report using DQL?

Your help is appreciated.

Thank you

With Regards

blessing Jacob

Find more posts tagged with

Comments

blessbk

Hi all,

I managed to find it. The DQL is as follows:-

Select a.object_name from dm_audittrail where event_name='dm_destroy'

Thank you

With Regards

blessing

DCTM_Guru

Keep in mind this will only tell you documents that have been deleted SINCE auditing was enabled. Any documents deleted before auditing was enabled will NOT show up. Also, you need to check if AuditMgmt job is running. This job will delete you audit trail passed a certain date (eg 90 days), so if this is job is running, then destroy events older than 90 days will be deleted and you will lose your "record" of what has been deleted.