Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OEA_OH_Idnr int NUMBER(38,0) int int false ID of the event.
OEA_EventType char (2) CHAR (2 CHAR) char(2) char (2) true Event type. TT = time event (timer), TS = time event (time of execution) FS = file system event, FT = file system event, FA = automatic file system event CN = console event, RN = rule event, ON = collector event
OEA_RepeatType char (1) CHAR (1 CHAR) char(1) char (1) true Repeat type of the event. R = check repeatedly, S = single check, F = check until first hit
OEA_Timeout1 varchar (6) VARCHAR2 (6 CHAR) varchar(6) varchar (6) true The time the event automatically ends. Format: TTHHMM
OEA_Timeout2 int NUMBER(38,0) int int true The duration (in seconds) the event automatically ends.
OEA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) varchar (16) true Name of the internal account.
OEA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Start type of the event.
OEA_ActAtRun smallint NUMBER(38,0) smallint smallint true Indicates that the object is generated at runtime or at activation time.
OEA_TExecType char (1) CHAR (1 CHAR) char(1) char (1) true TS: start after a certain time, E=execute N=no execute, TT S=start immediately
OEA_TimePeriod char (4) CHAR (4 CHAR) char(4) char (4) true Period in minutes or HHMM (depending on the event type).
OEA_EventSubType char (2) CHAR (2 CHAR) char(2) char (2) true Sub-type of the event. (e.g.: filesize, freespace, EY, EC, EA event system, event security, event application, O4 = OS/400 Console O3 = OS/390, A1 = OPENOUTPUT, A2 = CLOSEOUTPUT, A3 = ALLOUTPUT, S1 = SAP Events
OEA_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the destination agent the event will run on.
OEA_LoginDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the login object the event will use.
OEA_Path varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true The path to check.
OEA_Operator char (1) CHAR (1 CHAR) char(1) char (1) true Defines the operator used for the comparison. G = greater, L = less, E = equal, N = not equal, F=greater equal, K=less equal
OEA_Value int NUMBER(38,0) int int true The value to compare with.
OEA_Unit int NUMBER(38,0) int int true Unit of the value. 0 = host-specific, 1 = byte, 2 = KB, 3 = MB, 4 = GB, 5 =TB
OEA_ScriptType int NUMBER(38,0) int int true Process event script when check failed or timeout occurred. 1 = false 2 = timeout
OEA_Source varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Windows event: Source, OS/400: Message type
OEA_Category int NUMBER(38,0) int int true Windows event: category, OS/400: severity
OEA_TimePeriodTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Time zone for time period when HHMM is used
OEA_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Platform type of the agent.
OEA_EventSubType2 varchar (2) VARCHAR2 (2 CHAR) varchar(2) varchar (2) true Second check type. FC = File changed, FS = File stable
OEA_CheckWithin int NUMBER(38,0) int int true Defines how long (in seconds) the event checks back in time.
OEA_InclSubDir smallint NUMBER(38,0) smallint smallint true Indicates whether or not the file event check includes sub-directores.
OEA_ConsiderAll smallint NUMBER(38,0) smallint smallint true Indicates whether the file event considers all files or not.
OEA_OP1_Type varchar (6) VARCHAR2 (6 CHAR) varchar(6) varchar (6) true Type of first sql query (SQL, VARA, STATIC)
OEA_OP1_Sql varchar(4096) CLOB varchar(4096) varchar(4096) true SQL query
OEA_OP1_Host varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Host name of the database server.
OEA_OP1_Login varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Login object used for the database server.
OEA_OP1_Server varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Server name of the database.
OEA_OP1_Db varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the database.
OEA_OP1_File varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true File name of the database (MS-Access only).
OEA_OP1_Vara varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the VARA object.
OEA_OP1_Keyword varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Key within the VARA object.
OEA_OP1_Static varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Static expression.
OEA_OP2_Type varchar (6) VARCHAR2 (6 CHAR) varchar(6) varchar (6) true Type of second sql query (SQL, VARA, STATIC)
OEA_OP2_Sql varchar(4096) CLOB varchar(4096) varchar(4096) true SQL query
OEA_OP2_Host varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Host name of the database server.
OEA_OP2_Login varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Login object used for the database server.
OEA_OP2_Server varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Server name of the database.
OEA_OP2_Db varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the database.
OEA_OP2_File varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true File name of the database (MS-Access only).
OEA_OP2_Vara varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the VARA object.
OEA_OP2_Keyword varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Key within the VARA object.
OEA_OP2_Static varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Static expression.
OEA_StoreName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Identification of STORE object (EVNT.IA.* only).

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OEA OEA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OEA_OH OEA_OH_Idnr OH_Idnr

Return to the Index File