aaEventHistoryInsert
- Last UpdatedMar 10, 2025
- 1 minute read
Inserts a row into the EventHistory table for each occurrence of an event for a specified event tag. This stored procedure is used by the event subsystem and should not be modified.
Syntax
aaEventHistoryInsert TagName, DateTime, DetectDateTime, Edge
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. |
|
DateTime |
The timestamp reflecting when event history data was acquired. This is the time when an event actually occurred. This time reflects the time zone of the AVEVA Historian. This value is of data type datetime2(7), with no default. |
|
DetectDateTime |
The timestamp reflecting when the event was detected by the event system. This value is of data type datetime2(7), with no default. |
|
Edge |
The "edge" for the event detection. 0 = Trailing; 1 = Leading; 2 = Both; 3 = None; 4 = Time Detector; 5 = External Detector. This value is of data type int, with no default. |
Permission
Execute permission defaults to the aaAdministrators group.