View Revisions: Issue #3789
| Summary | 0003789: Sort SQL configuration export by primary key to make it easier to diff | ||
|---|---|---|---|
| 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 |
||
| 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:32 by hanes | ||
| Additional Information | CSV export looks like all the queries have an order by already. | ||
| Revision | 2018-11-08 17:13 by chenson | ||
| Additional Information | |||