# Log point

### ![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-olTwg7hZbNL0ezRh2%2F-M-om_z1_pirnoya82st%2Fhelp_root_applications_workflow_icons_logpoint.png?alt=media\&token=be162245-8585-42de-804a-10de0333f0d7)  <a href="#log-point" id="log-point"></a>

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:\
&#x20;[Log Point Workflow - Sql Server 2012](https://home.novacuraflow.com/Downloads/Customer/Example/Log%20Point%20-%20Sql%20Server%202012.zip)\
&#x20;[Log Point Workflow - Sql Server 2014](https://home.novacuraflow.com/Downloads/Customer/Example/Log%20Point%20-%20Sql%20Server%202014.zip)<br>

* If needed Sql server express can be downloaded here:
  * [Sql Server 2012 Express](https://www.microsoft.com/en-us/download/details.aspx?id=29062)
  * [Sql Server 2014 Express](https://www.microsoft.com/en-US/download/details.aspx?id=42299)
* Restore the database backup in sql server express management studio.
* Create a connector to the database.
* Import the [machine workflow](https://home.novacuraflow.com/Help/latest/?help_root_applications_workflow_workflow) (LogPointWorkflow) in the Flow studio.
* In [*Environment*](https://home.novacuraflow.com/Help/latest/?help_root_environment_environment) -> [*System Events*](https://home.novacuraflow.com/Help/latest/?help_root_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.

![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-olTwg7hZbNL0ezRh2%2F-M-omdQRhDmiOzgoDBys%2Fhelp_root_applications_workflow_images_log_database.png?alt=media\&token=c9d84d41-dcf4-44d9-a637-cde58200250b)

\
&#x20;**1.** Create a [machine workflow](https://home.novacuraflow.com/Help/latest/?help_root_applications_workflow_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](https://home.novacuraflow.com/Help/latest/?help_root_applications_workflow_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*.<br>
* 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).

![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-olTwg7hZbNL0ezRh2%2F-M-omil-0j9djbW7mtLY%2Fhelp_root_applications_workflow_images_log_workflow.png?alt=media\&token=986baa4c-d541-48c9-a23c-dc184d7f62bf)

**2.** Go to [*Environment*](https://home.novacuraflow.com/Help/latest/?help_root_environment_environment) -> [*System Events*](https://home.novacuraflow.com/Help/latest/?help_root_environment_system_events), and pick the [machine workflow](https://home.novacuraflow.com/Help/latest/?help_root_applications_workflow_workflow) for the log point system event and choose a user that will execute the log point system event.

![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-olTwg7hZbNL0ezRh2%2F-M-ompmrHMg74D8pEu-_%2Fhelp_root_applications_workflow_images_log_systemevent.png?alt=media\&token=249f3348-062f-49d2-98c3-10db36a8bbe5)

**3.** Add log points in workflows to log data.

![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-olTwg7hZbNL0ezRh2%2F-M-omty5ld84A3dXgNTy%2Fhelp_root_applications_workflow_images_log_workflowlogpoint.png?alt=media\&token=d9b85c93-4617-4409-b256-9cf67cdf2036)