TN AppSvr241 How to Query the A2ALMDB Database.

Description

This article from InSource shows How to Query the A2ALMDB database.

• Author: Benjamin Davis
• Published: 06/28/2017
• Applies to: Application Server 2014 R2

Details

Below is a sample query to query the A2ALMDB database.

USE A2ALMDB
SELECT EventStamp, Tagname, Area, Value
FROM v_AlarmHistory
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.