NA

General workflow information

SELECT task_name, task_state, actual_start_date, dequeued_date FROM  
dmi_queue_item WHERE router_id = ‘workflowId’​
 
 

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'​
 
 

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
 
 

Qualify job to use in job sequence

Jobs can only be used in 'job sequences' when the method inplementation of the job has a value for the attribute 'success_return_codes'. The DQL will append the value '0' (since this is the code indicating successful execution) to the implementing dm_method of the job

update dm_method object append "success_return_codes" = 0 where object_name  
in (select method_name from dm_job where object_name='My Job')
 
 

Show folder locations of an object

Shows the r_folder_path values from the dm_folder table for a specific object. The Fld.r_folder_path<>' ' where clause is added to filter the empty return values

SELECT Obj.r_object_id, Obj.object_name, Fld.r_folder_path
FROM dm_sysobject Obj, dm_folder_r Fld
WHERE any Obj.i_folder_id = Fld.r_object_id AND Obj.r_object_id='[OBJECT ID]'  
AND Fld.r_folder_path<>' '
 
 

DQL to get total number of documents and folders under a cabinet

It counts all documents stored in a given [CABINET/FOLDER] path.

SELECT count(*) AS cnt,'Docs' AS category
FROM dm_document(ALL)
WHERE FOLDER
('[CABINET/FOLDER]',DESCEND)