Configure a generic SQL detector

The AVEVA Historian does not validate SQL query syntax. First, test the SQL query using a tool such as Microsoft SQL Server Query Analyzer.

To configure a generic SQL detector

1. In the Detector Type list, select Generic SQL.

   

2. In the Time Interval box, type the interval, in milliseconds, at which the system checks to see if the event conditions specified by the detector occurred. This value must be greater than or equal to 500 milliseconds, and less than or equal to 1 hour (3600000 ms).

   Be careful assigning time intervals to event tags. For more information, see Time intervals for SQL-based detectors.

3. In the Detector Query window, enter the ad-hoc query that detects the event. To open a list of SQL templates to use for your query, click Templates.

4. To clear the window, click Clear.