# 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)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.novacuraflow.com/6.12/development/flow-studio/applications/workflow/log-point.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
