OTM --Data Tables for Agent Migration

Data Tables for Agent Migration

1	AGENT_EVENT 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 ')