aaEventDetection
- Last UpdatedMar 10, 2025
- 2 minute read
Detects the number of events in history in which the data value for the specified tag matched the criteria defined by the remaining arguments. This stored procedure is used by the event subsystem and should not be modified.
Syntax
aaEventDetection TagName, Operator, DetectValue, Edge, Resolution, StartTime, EndTime
where:
|
Argument |
Description |
|---|---|
|
TagName |
The unique name of the tag within the AVEVA Historian system. This value is of data type nvarchar(256), with no default. |
|
Operator |
The comparison operator. Valid values are:
|
|
DetectValue |
The value against which the stored values for the tag are compared to determine if the event occurred. This value is of data type float(25), with a default of none. |
|
Edge |
The type of edge detection result set that the query will return. Valid values are:
|
|
Resolution |
The sampling rate, in milliseconds, for retrieving the data in cyclic mode. The system returns values stored over the requested time period at the interval specified by the resolution. For example, if you specify a 5000 ms resolution, the system queries for all data during the time period and then only returns those values that occur at each 5000 ms interval, starting with the start date and ending with the end date. This value is of data type int, with no default. |
|
StartTime |
The starting timestamp for the data to query. This value is of dataype varchar(30), with no default. |
|
EndTime |
The ending timestamp for the data to query. This value is of dataype varchar(30), with no default. |
Remarks
You can apply a resolution only if you set the value of the Edge argument to NONE.
Permission
Execute permission defaults to the aaAdministrators group.