Downtime Event Table properties
- Last UpdatedSep 10, 2023
- 1 minute read
Refer to the following table for the key configurable properties of the Event Table.
Field Type properties
|
Property |
Description |
Valid values |
|---|---|---|
|
EventTableName |
The name of the table to use for the event data. Ensure that the value for this property is set to EventTable. |
EventTable |
|
WindowSize |
The window of time, in minutes, to use when events are searched. The format for this value is timespan format; for example, D:HH:MM:SS. The default window size is 1 hour. Note: Be careful to not set the window size too large as this reduces the likelihood of the correct event being selected. For a diagram that illustrates the relationship between the WindowSize property and events, see Relationship between WindowSize and Events. |
Read properties
|
Property |
Description |
Valid values |
|---|---|---|
|
SelectCommand |
An OLE DB command object that contains the SQL Select statement. Sub properties:
|
Update properties
|
Property |
Description |
Valid values |
|---|---|---|
|
DeleteCommand |
An OLE DB command object that contains the SQL DELETE statement. |
|
|
InsertCommand |
An OLE DB command object that contains the SQL INSERT statement. |
|
|
UpdateCommand |
An OLE DB command object that contains the SQL UPDATE statement. |