Audits

The database for Workflow Composer 3.0.1.8 and later provides a WorkflowDefinitionVersion_Audit table that logs workflow definition version changes. Records are inserted into the new table when workflow definition versions are updated (enabled/disabled) and deleted.

Newly published (inserted) workflow definition versions are stored in the WorkflowDefinitionVersion table. When a workflow definition version is first published (inserted) no audit records appear in the WorkflowDefinitionVersion_Audit table. However, a View of the WorkflowDefinitionVersion_Audit provides details of newly created workflow definition versions.

alert Workflow auditing is not supported for standalone CampusNexus CRM deployments.  

Queries

To query the View of the WorkflowDefinitionVersion_Audit in MS SQL Server Management Studio, you can use Select statements such as:

select top 10 * from Vw_WorkflowDefinitionVersion_Audit order by DateLstMod desc
select * from Vw_WorkflowDefinitionVersion_Audit order by Comment
select * from Vw_WorkflowDefinitionVersion_Audit where WorkflowDefinitionVersionID='nnnn'

Examples

To audit the status of your workflow versions, check the values in the IsEnabled and Comment columns of the WorkflowDefinitionVersion_Audit view.

  • When you create, enable, and publish a workflow version, IsEnabled is set to 1, and the Comment field shows a record is inserted.

  • When you disable a workflow version, IsEnabled is set to 0, and the Comment field shows that the record is updated.

  • When you delete a workflow version, IsEnabled is set to 0, and the Comment field shows that the record is deleted.

Add a workflow