Commonly used DQLs for Documentum Admins. I update this blog whenever i get some good DQL to write , its for my personal reference as well as for other user if it helps anybody. Please use it at your own risk.

1- To see the audit trail for the particular user's login attempt to troubleshoot login related issues.

SELECT * FROM dm_audittrail
WHERE event_name='dm_connect'
AND user_name='user_name'

2- Group by clause by date to calcuate the number of documents create each day in the repository. Modify it accordingly as per your need.

select (DATEFLOOR(DAY, r_creation_date)) as r_MONTH , count(*)as cnt from amtrak_invoice where r_creation_date >= date('06/06/2011') GROUP BY (DATEFLOOR(DAY, r_creation_date))order by 1