Create a database view of a data log group

Database views of a data log group's values and collected data can be created for analysis and reporting.

The view name is vw_data_log_GroupDescription.The view will have column names that match the data log value names and the columns are cast to the defined data type of the data log value. Unused values are also returned as strings with the column names Valuen. If the group description or a data log value has a space in the name, the space will be removed in the view name and column name.

If changes are subsequently made to the data log values within the group, the view can be recreated. If the group name is changed, a new view will be created with the new name and the existing view will have to be deleted from the database using SQL Server.

You must have the May edit data logging user privilege to create data log group views.

Create or recreate a data log group database view

1. Select the data log group.

2. In the Properties window, click the Create View button.

   A message confirms that the view was created and shows the name of the view.