Snippets
Share your snippets!
Do you want to contribute and add your own snippets?
Start sharing your information here!
You don't have an account?
Create it here.
List of attachments for a specific workflow
SELECT r_component_id, r_component_name FROM dmi_wf_attachment WHERE r_workflow_id = '< workflow ID >'
Number of versions for a specific object
Object versions are related to each other by the i_chronicle_id attribute. The DQL counts the number of objects with the same i_chronicle_id. Any r_object_id of a document in the version tree can be used
SELECT count(r_object_id) FROM dm_sysobject (ALL) WHERE i_chronicle_id IN (SELECT i_chronicle_id FROM dm_sysobject WHERE r_object_id='< object id >'
List of failed authentication attempts (audit trail)
SELECT * FROM dm_audittrail WHERE event_name='dm_logon_failure'
Physical location of a file stored in the docbase
Files stored in Documentum are written to the content storage of the content server. To find the physical location of those objects on the disc, use the getpath command
DQL : Execute get_file_url FOR < object id > API : getpath,c,< object id >
Submit object to indexing server
Send an object to the index queue
queue,c,,dm_fulltext_index_user,dm_save
Enable/Disable email notifications for all users
To disable mail notifications, edit/add the mail_notification property in the server.ini file. When the property is not available, the default behaviour will be 'True'
File : server.ini mail_notification = False