Skip to main content
InSource Solutions

TN AppSvr241 How to Query the A2ALMDB Database.

InSource_Logo_Transparent (1).png

 

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.


1.png