OTM --Data Tables for Agent Migration
Any custom agent events stores here SELECT AGENT_EVENT_GID, AGENT_EVENT_XID, DATA_QUERY_TYPE_GID, NOTIFY_SUBJECT_GID, STATUS_TYPE_GID, STATUS_VALUE_GID, AGENT_EVENT_PARENT, EVENT_TOPIC_CLASS, IS_CUSTOM, IS_LIFETIME_MOD, DOMAIN_NAME FROM AGENT_EVENT where AGENT_EVENT_XID in ('?condition?') ?2? SAVED_QUERY
Stores SQL statement used in agent. select SAVED_QUERY_GID, SAVED_QUERY_XID, QUERY_NAME, USER_QUERY_NAME, SQL_FIND_ALL, SQL_CHECK_ONE, USE_IN_FINDER, DOMAIN_NAME from SAVED_QUERY where SAVED_QUERY_XID in ('?condition?') ?3? SAVED_CONDITION
Stores Saved Condition. select SAVED_CONDITION_GID, SAVED_CONDITION_XID, QUERY_NAME, USER_CONDITION_NAME, DOMAIN_NAME from SAVED_CONDITION where SAVED_CONDITION_XID in ('?condition?') ?4? SAVED_CONDITION_QUERY
Link between Saved Query and Saved Condition select SAVED_CONDITION_GID, SAVED_QUERY_GID, DOMAIN_NAME from SAVED_CONDITION_QUERY where SAVED_CONDITION_GID in ('?condition?') ?5? AGENT
Contains agent header details. select AGENT_GID, AGENT_XID, DATA_QUERY_TYPE_GID, SAVED_CONDITION_GID, REENTRANCY_LEVEL, IS_ACTIVE, DOMAIN_NAME from AGENT where AGENT_GID in ('?condition?') ?6? AGENT_ACTION_DETAILS
Stores all agent actions. select AGENT_GID, ACTION_FLOW, ACTION_SEQUENCE, AGENT_ACTION_GID, ACTION_PARAMETERS, DOMAIN_NAME from AGENT_ACTION_DETAILS where AGENT_GID in ('?condition?') ?7? AGENT_EVENT_DETAILS
Stores agent events (listed in the agent header in UI). select AGENT_GID, AGENT_EVENT_GID, AGENT_EVENT_PARAMETERS, DOMAIN_NAME from AGENT_EVENT_DETAILS where AGENT_GID in ('?condition?')