TN WW106 How to Query the Microsoft SQL Alarm Database

Description

• Author: Daniel London
• Published: 04/30/2015
• Applies to: Microsoft SQL Server (All Versions)

Details

Sometimes it will be useful to query the Microsoft SQL Server (SQL) alarm database to ensure that the Alarm DB Logger Manager is logging historical alarms.

This database is listed as A2ALMDB for newer Wonderware software versions or WWALMDB for older versions.

A simple query can be executed to determine if the alarms are being stored as records in the database.

1. Open up Microsoft SQL Server Management Studio, expand the Databases folder, right click the alarm database and select New Query.
   
2. Next type and execute the following Query:
   
   SELECT * FROM v_AlarmEventHistory;
   
   Your alarms show in the Results section as records in the database.