View Revisions: Issue #3789

Back to Issue
Summary 0003789: Sort SQL configuration export by primary key to make it easier to diff
Revision 2018-11-08 17:13 by chenson
Description Sort csv configuration export by primary key to make it easier to diff
Revision 2018-11-08 17:14 by chenson
Description Sort sql & csv configuration export by primary key to make it easier to diff
Revision 2018-12-05 20:27 by hanes
Description Sort sql & csv configuration export by primary key to make it easier to diff.

All but one query seems to have an order by. The one that doesn't have an order by is:

[gui] - JdbcSqlTemplate - (1ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c

which seems to be the 46th query run when you do an export.
Revision 2018-12-05 20:32 by hanes
Description Sort sql & csv configuration export by primary key to make it easier to diff.
Revision 2018-11-08 17:13 by chenson
Additional Information
Revision 2018-12-05 20:32 by hanes
Additional Information CSV export looks like all the queries have an order by already.
Revision 2018-12-05 20:35 by hanes
Description Sort SQL configuration export by primary key to make it easier to diff.
Revision 2018-12-05 20:35 by hanes
Additional Information CSV export looks like all the queries have an order by already.


[gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP"
[gui] - JdbcSqlTemplate - (0ms.) select "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "DATA_EVENT_ACTION", "SYNC_CONFIG_ENABLED", "IS_REVERSIBLE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP_LINK"
[gui] - JdbcSqlTemplate - (0ms.) select "EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY", "PARAM_VALUE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_PARAMETER"
[gui] - JdbcSqlTemplate - (0ms.) select "CHANNEL_ID", "PROCESSING_ORDER", "MAX_BATCH_SIZE", "MAX_BATCH_TO_SEND", "MAX_DATA_TO_ROUTE", "EXTRACT_PERIOD_MILLIS", "ENABLED", "USE_OLD_DATA_TO_ROUTE", "USE_ROW_DATA_TO_ROUTE", "USE_PK_DATA_TO_ROUTE", "RELOAD_FLAG", "FILE_SYNC_FLAG", "CONTAINS_BIG_LOB", "BATCH_ALGORITHM", "DATA_LOADER_TYPE", "DESCRIPTION", "QUEUE", "MAX_NETWORK_KBPS", "DATA_EVENT_ACTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CHANNEL"
[gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME", "ENABLED" from "SYM_NODE_GROUP_CHANNEL_WND"
[gui] - JdbcSqlTemplate - (1ms.) select "TRIGGER_ID", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "SYNC_ON_INCOMING_BATCH", "NAME_FOR_UPDATE_TRIGGER", "NAME_FOR_INSERT_TRIGGER", "NAME_FOR_DELETE_TRIGGER", "SYNC_ON_UPDATE_CONDITION", "SYNC_ON_INSERT_CONDITION", "SYNC_ON_DELETE_CONDITION", "CUSTOM_BEFORE_UPDATE_TEXT", "CUSTOM_BEFORE_INSERT_TEXT", "CUSTOM_BEFORE_DELETE_TEXT", "CUSTOM_ON_UPDATE_TEXT", "CUSTOM_ON_INSERT_TEXT", "CUSTOM_ON_DELETE_TEXT", "EXTERNAL_SELECT", "TX_ID_EXPRESSION", "CHANNEL_EXPRESSION", "EXCLUDED_COLUMN_NAMES", "INCLUDED_COLUMN_NAMES", "SYNC_KEY_NAMES", "USE_STREAM_LOBS", "USE_CAPTURE_LOBS", "USE_CAPTURE_OLD_DATA", "USE_HANDLE_KEY_UPDATES", "STREAM_ROW", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER"
[gui] - JdbcSqlTemplate - (0ms.) select "ROUTER_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "ROUTER_TYPE", "ROUTER_EXPRESSION", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "USE_SOURCE_CATALOG_SCHEMA", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_ROUTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ORDER", "INITIAL_LOAD_SELECT", "INITIAL_LOAD_DELETE_STMT", "PING_BACK_ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER_ROUTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TRANSFORM_POINT", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "UPDATE_FIRST", "UPDATE_ACTION", "DELETE_ACTION", "TRANSFORM_ORDER", "COLUMN_POLICY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_TABLE"
[gui] - JdbcSqlTemplate - (0ms.) select "LOAD_FILTER_ID", "LOAD_FILTER_TYPE", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "FILTER_ON_UPDATE", "FILTER_ON_INSERT", "FILTER_ON_DELETE", "BEFORE_WRITE_SCRIPT", "AFTER_WRITE_SCRIPT", "BATCH_COMPLETE_SCRIPT", "BATCH_COMMIT_SCRIPT", "BATCH_ROLLBACK_SCRIPT", "HANDLE_ERROR_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "LOAD_FILTER_ORDER", "FAIL_ON_ERROR" from "SYM_LOAD_FILTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME", "SOURCE_COLUMN_NAME", "PK", "TRANSFORM_TYPE", "TRANSFORM_EXPRESSION", "TRANSFORM_ORDER", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_COLUMN"
[gui] - JdbcSqlTemplate - (0ms.) select "CONFLICT_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CHANNEL_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "DETECT_TYPE", "DETECT_EXPRESSION", "RESOLVE_TYPE", "PING_BACK", "RESOLVE_CHANGES_ONLY", "RESOLVE_ROW_ONLY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CONFLICT"
[gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "GROUPLET_LINK_POLICY", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET"
[gui] - JdbcSqlTemplate - (1ms.) select "GROUPLET_ID", "EXTERNAL_ID", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET_LINK"
[gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_TRIGGER_ROUTER_GROUPLET"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "BASE_DIR", "RECURSE", "INCLUDES_FILES", "EXCLUDES_FILES", "SYNC_ON_CREATE", "SYNC_ON_MODIFIED", "SYNC_ON_DELETE", "SYNC_ON_CTL_FILE", "DELETE_AFTER_SYNC", "BEFORE_COPY_SCRIPT", "AFTER_COPY_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ENABLED", "TARGET_BASE_DIR", "CONFLICT_STRATEGY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER_ROUTER"
[gui] - JdbcSqlTemplate - (1ms.) select "EXTENSION_ID", "EXTENSION_TYPE", "INTERFACE_NAME", "NODE_GROUP_ID", "ENABLED", "EXTENSION_ORDER", "EXTENSION_TEXT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_EXTENSION"
[gui] - JdbcSqlTemplate - (0ms.) select "MONITOR_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "TYPE", "EXPRESSION", "THRESHOLD", "RUN_PERIOD", "RUN_COUNT", "SEVERITY_LEVEL", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_MONITOR"
[gui] - JdbcSqlTemplate - (1ms.) select "NOTIFICATION_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "SEVERITY_LEVEL", "TYPE", "EXPRESSION", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NOTIFICATION"
[gui] - JdbcSqlTemplate - (0ms.) select "JOB_NAME", "JOB_TYPE", "REQUIRES_REGISTRATION", "JOB_EXPRESSION", "DESCRIPTION", "DEFAULT_SCHEDULE", "DEFAULT_AUTO_START", "NODE_GROUP_ID", "CREATE_BY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_JOB"
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where severity_level >= 300 and is_resolved = 0 order by event_time desc
[corp-000] - JdbcSqlTemplate - (1ms.) select node_id, queue from sym_extract_request where status='NE' group by node_id, queue
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, external_id, node_group_id, type, expression, enabled, threshold, run_period, run_count, severity_level, create_time, last_update_by, last_update_time from sym_monitor where (node_group_id = 'corp' or node_group_id = 'ALL') and (external_id = '000' or external_id = 'ALL') and enabled = 1
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where node_id = '000' and is_resolved = 0
Revision 2018-12-05 20:36 by hanes
Additional Information CSV export looks like all the queries have an order by already. SQL needs order by still, as shown (there may be additional sql at the end of this list unrelated to the export)


[gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP"
[gui] - JdbcSqlTemplate - (0ms.) select "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "DATA_EVENT_ACTION", "SYNC_CONFIG_ENABLED", "IS_REVERSIBLE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NODE_GROUP_LINK"
[gui] - JdbcSqlTemplate - (0ms.) select "EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY", "PARAM_VALUE", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_PARAMETER"
[gui] - JdbcSqlTemplate - (0ms.) select "CHANNEL_ID", "PROCESSING_ORDER", "MAX_BATCH_SIZE", "MAX_BATCH_TO_SEND", "MAX_DATA_TO_ROUTE", "EXTRACT_PERIOD_MILLIS", "ENABLED", "USE_OLD_DATA_TO_ROUTE", "USE_ROW_DATA_TO_ROUTE", "USE_PK_DATA_TO_ROUTE", "RELOAD_FLAG", "FILE_SYNC_FLAG", "CONTAINS_BIG_LOB", "BATCH_ALGORITHM", "DATA_LOADER_TYPE", "DESCRIPTION", "QUEUE", "MAX_NETWORK_KBPS", "DATA_EVENT_ACTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CHANNEL"
[gui] - JdbcSqlTemplate - (0ms.) select "NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME", "ENABLED" from "SYM_NODE_GROUP_CHANNEL_WND"
[gui] - JdbcSqlTemplate - (1ms.) select "TRIGGER_ID", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "SYNC_ON_INCOMING_BATCH", "NAME_FOR_UPDATE_TRIGGER", "NAME_FOR_INSERT_TRIGGER", "NAME_FOR_DELETE_TRIGGER", "SYNC_ON_UPDATE_CONDITION", "SYNC_ON_INSERT_CONDITION", "SYNC_ON_DELETE_CONDITION", "CUSTOM_BEFORE_UPDATE_TEXT", "CUSTOM_BEFORE_INSERT_TEXT", "CUSTOM_BEFORE_DELETE_TEXT", "CUSTOM_ON_UPDATE_TEXT", "CUSTOM_ON_INSERT_TEXT", "CUSTOM_ON_DELETE_TEXT", "EXTERNAL_SELECT", "TX_ID_EXPRESSION", "CHANNEL_EXPRESSION", "EXCLUDED_COLUMN_NAMES", "INCLUDED_COLUMN_NAMES", "SYNC_KEY_NAMES", "USE_STREAM_LOBS", "USE_CAPTURE_LOBS", "USE_CAPTURE_OLD_DATA", "USE_HANDLE_KEY_UPDATES", "STREAM_ROW", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER"
[gui] - JdbcSqlTemplate - (0ms.) select "ROUTER_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "ROUTER_TYPE", "ROUTER_EXPRESSION", "SYNC_ON_UPDATE", "SYNC_ON_INSERT", "SYNC_ON_DELETE", "USE_SOURCE_CATALOG_SCHEMA", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_ROUTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ORDER", "INITIAL_LOAD_SELECT", "INITIAL_LOAD_DELETE_STMT", "PING_BACK_ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRIGGER_ROUTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TRANSFORM_POINT", "SOURCE_CATALOG_NAME", "SOURCE_SCHEMA_NAME", "SOURCE_TABLE_NAME", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "UPDATE_FIRST", "UPDATE_ACTION", "DELETE_ACTION", "TRANSFORM_ORDER", "COLUMN_POLICY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_TABLE"
[gui] - JdbcSqlTemplate - (0ms.) select "LOAD_FILTER_ID", "LOAD_FILTER_TYPE", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "FILTER_ON_UPDATE", "FILTER_ON_INSERT", "FILTER_ON_DELETE", "BEFORE_WRITE_SCRIPT", "AFTER_WRITE_SCRIPT", "BATCH_COMPLETE_SCRIPT", "BATCH_COMMIT_SCRIPT", "BATCH_ROLLBACK_SCRIPT", "HANDLE_ERROR_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "LOAD_FILTER_ORDER", "FAIL_ON_ERROR" from "SYM_LOAD_FILTER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME", "SOURCE_COLUMN_NAME", "PK", "TRANSFORM_TYPE", "TRANSFORM_EXPRESSION", "TRANSFORM_ORDER", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_TRANSFORM_COLUMN"
[gui] - JdbcSqlTemplate - (0ms.) select "CONFLICT_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID", "TARGET_CHANNEL_ID", "TARGET_CATALOG_NAME", "TARGET_SCHEMA_NAME", "TARGET_TABLE_NAME", "DETECT_TYPE", "DETECT_EXPRESSION", "RESOLVE_TYPE", "PING_BACK", "RESOLVE_CHANGES_ONLY", "RESOLVE_ROW_ONLY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_CONFLICT"
[gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "GROUPLET_LINK_POLICY", "DESCRIPTION", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET"
[gui] - JdbcSqlTemplate - (1ms.) select "GROUPLET_ID", "EXTERNAL_ID", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_GROUPLET_LINK"
[gui] - JdbcSqlTemplate - (0ms.) select "GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_TRIGGER_ROUTER_GROUPLET"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "CHANNEL_ID", "RELOAD_CHANNEL_ID", "BASE_DIR", "RECURSE", "INCLUDES_FILES", "EXCLUDES_FILES", "SYNC_ON_CREATE", "SYNC_ON_MODIFIED", "SYNC_ON_DELETE", "SYNC_ON_CTL_FILE", "DELETE_AFTER_SYNC", "BEFORE_COPY_SCRIPT", "AFTER_COPY_SCRIPT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER"
[gui] - JdbcSqlTemplate - (0ms.) select "TRIGGER_ID", "ROUTER_ID", "ENABLED", "INITIAL_LOAD_ENABLED", "TARGET_BASE_DIR", "CONFLICT_STRATEGY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME", "DESCRIPTION" from "SYM_FILE_TRIGGER_ROUTER"
[gui] - JdbcSqlTemplate - (1ms.) select "EXTENSION_ID", "EXTENSION_TYPE", "INTERFACE_NAME", "NODE_GROUP_ID", "ENABLED", "EXTENSION_ORDER", "EXTENSION_TEXT", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_EXTENSION"
[gui] - JdbcSqlTemplate - (0ms.) select "MONITOR_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "TYPE", "EXPRESSION", "THRESHOLD", "RUN_PERIOD", "RUN_COUNT", "SEVERITY_LEVEL", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_MONITOR"
[gui] - JdbcSqlTemplate - (1ms.) select "NOTIFICATION_ID", "NODE_GROUP_ID", "EXTERNAL_ID", "SEVERITY_LEVEL", "TYPE", "EXPRESSION", "ENABLED", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_NOTIFICATION"
[gui] - JdbcSqlTemplate - (0ms.) select "JOB_NAME", "JOB_TYPE", "REQUIRES_REGISTRATION", "JOB_EXPRESSION", "DESCRIPTION", "DEFAULT_SCHEDULE", "DEFAULT_AUTO_START", "NODE_GROUP_ID", "CREATE_BY", "CREATE_TIME", "LAST_UPDATE_BY", "LAST_UPDATE_TIME" from "SYM_JOB"
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where severity_level >= 300 and is_resolved = 0 order by event_time desc
[corp-000] - JdbcSqlTemplate - (1ms.) select node_id, queue from sym_extract_request where status='NE' group by node_id, queue
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, external_id, node_group_id, type, expression, enabled, threshold, run_period, run_count, severity_level, create_time, last_update_by, last_update_time from sym_monitor where (node_group_id = 'corp' or node_group_id = 'ALL') and (external_id = '000' or external_id = 'ALL') and enabled = 1
[corp-000] - JdbcSqlTemplate - (1ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where node_id = '000' and is_resolved = 0