Log point

The log point can for example be used to measure time or debug workflows. Log points capture the value of the checked variables and can be stored in a database thru a connected workflow in system events.

Download a basic log point workflow and a Sql server database here: Log Point Workflow - Sql Server 2012 Log Point Workflow - Sql Server 2014

• If needed Sql server express can be downloaded here:

  • Sql Server 2012 Express

  • Sql Server 2014 Express

• Restore the database backup in sql server express management studio.

• Create a connector to the database.

• Import the machine workflow (LogPointWorkflow) in the Flow studio.

• In Environment -> System Events, pick the machine workflow (LogPointWorkflow) for the log point system event and choose a user that will execute the log point system event.

• Now should data be logged when the workflow steps over a log point.

1. Create a machine workflow. This workflow will run every time a workflow steps over a log point.

• Use in-parameters to get the log point data into the machine workflow. Download the example above to see how the in-parameters should be configured or look at the picture of the workflow below.

  • Create a record variable named LogPoint, with variable; Name, TimeStamp, WorkflowName and a table Data with variable Key and Value.

• Use a connector to the database where the logged data will be stored. Download the example above to get a database (other types of databases can also be used).

2. Go to Environment -> System Events, and pick the machine workflow for the log point system event and choose a user that will execute the log point system event.

3. Add log points in workflows to log data.