How can I make sure the audittrail for workflow reporting is always ON and not turned OFF at anytime. Workflow reporting is critical for us and it breaks for every install on the process templates. It requires a manual validation which fails sometimes.
I am planning to write a monitoring script which validates the below DQL periodically and sends notification if 0 rows returned or event value is not equal to dm_all_workflow.
select r_object_id, registered_id, event from dmi_registry where registered_id in (select i_chronicle_id from dm_process(all) where r_object_id = 'rObjId')
The rObjId in the above query is the r_object_id of dm_process object.
I have few questions on this regard
1) Do I need to monitor any other attributes in addition to make sure the audittrail is turned ON or is there a alternate/better way to do this.
2) Does the above solution always works ? The workflow reporting or writing events in audittrail should not fail/disabled even after the above query return records.
3) Is there a way to replicate workflow reporting instead relying on audittrail. i.e., Can we restructure the way workflow reporting works, Instead of writing it to audittrail for the registered events, I want to customize to write it to our custom tables.
Please let me know if someone has more information on this or can help in this regard. Thanks
- Viswazith
