Retrieve live values

You can retrieve the current data values for specified tags.

To retrieve live values:

1. In cells in your worksheet, enter one or more tagnames (one tagname per cell). For more information, see Selecting Tags for Reports.

2. On the Historian tab, in the Tag Management group, click Tag Values, and then click Live Values. The Live Values - Step 1 of 3 dialog box appears.

3. In the Server list, click the name of the server to use.

4. Select the Support multiple data types check box to allow for the selection of dissimilar data types for the same query. That is, a mix of analog, discrete, string, and/or event tags.

5. In the Select cell(s) containing tag name(s) list, specify the location of the worksheet cell(s) that contains the tag name(s). Click on the button to select the cell(s). For more information, see Selecting Cells.

6. If you want to use a named tag range variable instead, click Binding Options and then configure the range. For more information, see Using "Binding" Tags to a Query at Run Time.

7. Click Next. The Live Values - Step 2 of 3 dialog box appears.

8. In the Select cell for output list, specify the location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.

9. Select the Enter the results as an array-formula check box to insert the results as an array formula. An array formula can perform one or more calculations and then return either single result or multiple results. An array formula allows for the resending of the query, since the query parameters are included in the cells that contain the query results. For more information, see Working with Functions, Formulas, and Cells.

10. Select the Select cells to specify format options check box to specify a range of cells that contain formatting information. The formatting information in the cells will be applied to the query results. For more information, see Selecting Cells.

11. Click Next. The Live Values - Step 3 of 3 dialog box appears.

12. Configure the criteria for the query.

    • Tag name: The name of the tag within the AVEVA Historian server. If the data values are coming from Application Server, the attribute reference is shown as the tag name. You can also choose to show the hierarchical name along with the attribute reference. For more information, see ArchestrA Naming Conventions.

    • Date time: The time stamp for the returned value. For delta retrieval, this is the time at which the value was acquired by the AVEVA Historian. For cyclic retrieval, this is the specific time requested or calculated (using a SQL function).

    • Include milliseconds: Used to include milliseconds in the timestamp.

    • Quality: The basic data quality indicator associated with the data value.

    • Replace poor quality values: The text string of "poor" will replace the current value if the value has a quality <> 0 or 133.

    • Detect date time: Only applicable to event tags. The timestamp reflecting when the event was detected by the event system.

    • OPC Quality: The quality value received from the data source. Only available if you selected the Support multiple data types check box in the Live Values - Step 1 of 3 dialog box (see step 4 above).

    • Source Tag: The source tag of the tag.

    • Source Server: The source server of the tag.

13. Click Finish.