Show when a user’s properties were last changed:
SELECT r_modify_date FROM dm_user WHERE user_name = ''
List all deactivated user accounts:
SELECT user_name FROM dm_user WHERE user_state = 1
List the LDAP servers being used to authenticate users:
SELECT user_login_domain FROM dm_user WHERE user_source = 'LDAP'
List documents currently checked out by a particular user:
SELECT object_name FROM dm_document WHERE r_lock_owner = ''
Find the list of users who have not logged into Documentum for X no of days:
SELECT user_name,user_os_name,last_login_utc_time from dm_user where datediff(day,last_login_utc_time,date(today)) and user_name not like 'dm%' order by last_login_utc_time desc,user_name