Filtering the user created documents & folders from dm_audittrail object

blessbk

Hi,

We are using Documentum 6.5 sp2

We have enabled the audit trail to audit all the documents and folders saved in the repository. From our .Net application we want to list down all the user created or modified documents/folders on daily basis. Whenever we run the below mentioned dql, the system returns all the documents and folders along with the system generated docs and etc.

select * from dm_audittrail where event_name ='dm_save' and object_type in ('dm_document','dm_folder');

Is there anyway we can filter out using a dql query.

We need some thing like

select * from dm_audittrail where cabinet ('/dmadmin', descend) and event_name ='dm_save' and object_type in ('dm_document','dm_folder');

please advice us.

Thanks & Regards

bless

bacham2

Filter on the user_name attribute to exclude dmadmin. You may need to exclude other users such as dm_fulltext_index_user or docbase owner.