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 imparameters to get the log point data into the machine workflow. Download the example above to see how the imparameters 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.