Querying the Live table

The Live table presents the latest available streamed data for each tag in the table.

Note: In certain situations, data can bypass the Live table. These situations include:
- Receiving non-streamed original data (store/forward or CSV);
- Receiving revision data for a Latest value;
- Receiving no new streamed values after Historian was shut down and disabled, or after the computer was rebooted.

For more information, see History Tables and Views in the AVEVA Historian Database Reference.

The following query returns the current value of the specified tag. The query uses the remote table view (Live is used in place of INSQL.Runtime.dbo.Live).

SELECT TagName, Value

FROM Live

WHERE TagName = 'ReactLevel'

The result is: