This article from InSource shows How to Query the A2ALMDB database.
- Author: Benjamin Davis
- Published: 06/28/2017
- Applies to: Application Server 2014 R2
Below is a sample query to query the A2ALMDB database.
SELECT EventStamp, Tagname, Area, Value
WHERE Tagname LIKE '%Water%'
AND EventStamp > '2017-04-04 13:00'
AND EventStamp <= '2017-07-04 15:00'
AND Value >= '70'
Text shown in green is comments to help clarify.