v2.5.1
sql 脚本 - DDL
sql
-- 监控告警记录
DROP TABLE IF EXISTS `monitor_alarm_event`;
CREATE TABLE `monitor_alarm_event`
(
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`agent_key` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'agentKey',
`host_id` bigint(0) NULL DEFAULT NULL COMMENT '主机id',
`host_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '主机名称',
`host_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '主机地址',
`policy_id` bigint(0) NULL DEFAULT NULL COMMENT '策略id',
`policy_rule_id` bigint(0) NULL DEFAULT NULL COMMENT '策略规则id',
`metrics_id` bigint(0) NULL DEFAULT NULL COMMENT '指标id',
`metrics_measurement` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '指标数据集',
`alarm_tags` json NULL COMMENT '告警标签',
`alarm_value` decimal(19, 4) NULL DEFAULT NULL COMMENT '告警值',
`alarm_threshold` decimal(19, 4) NULL DEFAULT NULL COMMENT '告警阈值',
`alarm_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '告警摘要',
`alarm_level` tinyint(0) NULL DEFAULT NULL COMMENT '告警级别',
`trigger_condition` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '告警条件',
`consecutive_count` int(0) NULL DEFAULT NULL COMMENT '连续触发次数',
`false_alarm` tinyint(0) NULL DEFAULT NULL COMMENT '是否误报',
`handle_status` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '处理状态',
`handle_time` datetime(0) NULL DEFAULT NULL COMMENT '处理时间',
`handle_remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '处理备注',
`handle_user_id` bigint(0) NULL DEFAULT NULL COMMENT '处理人id',
`handle_username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '处理人用户名',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(0) NULL DEFAULT 0 COMMENT '是否删除 0未删除 1已删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_host_id` (`host_id`) USING BTREE,
INDEX `idx_agent_key` (`agent_key`) USING BTREE,
INDEX `idx_handle_user` (`handle_user_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci COMMENT = '监控告警记录'
ROW_FORMAT = Dynamic;
-- 监控告警策略
DROP TABLE IF EXISTS `monitor_alarm_policy`;
CREATE TABLE `monitor_alarm_policy`
(
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '策略名称',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '策略描述',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(0) NULL DEFAULT 0 COMMENT '是否删除 0未删除 1已删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci COMMENT = '监控告警策略'
ROW_FORMAT = Dynamic;
-- 监控告警策略通知
DROP TABLE IF EXISTS `monitor_alarm_policy_notify`;
CREATE TABLE `monitor_alarm_policy_notify`
(
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`policy_id` bigint(0) NULL DEFAULT NULL COMMENT '策略id',
`notify_id` bigint(0) NULL DEFAULT NULL COMMENT '通知id',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(0) NULL DEFAULT 0 COMMENT '是否删除 0未删除 1已删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_policy_id` (`policy_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci COMMENT = '监控告警策略通知'
ROW_FORMAT = Dynamic;
-- 监控告警策略规则
DROP TABLE IF EXISTS `monitor_alarm_policy_rule`;
CREATE TABLE `monitor_alarm_policy_rule`
(
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`policy_id` bigint(0) NULL DEFAULT NULL COMMENT '策略id',
`metrics_id` bigint(0) NULL DEFAULT NULL COMMENT '指标id',
`metrics_measurement` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '指标数据集',
`tags` json NULL COMMENT '指标标签',
`rule_switch` tinyint(0) NULL DEFAULT NULL COMMENT '规则开关',
`all_effect` tinyint(0) NULL DEFAULT 0 COMMENT '全部生效',
`level` tinyint(0) NULL DEFAULT NULL COMMENT '告警级别',
`trigger_condition` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '告警条件',
`threshold` decimal(19, 4) NULL DEFAULT NULL COMMENT '触发阈值',
`silence_period` int(0) NULL DEFAULT NULL COMMENT '静默时间',
`consecutive_count` int(0) NULL DEFAULT NULL COMMENT '连续触发次数',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '规则描述',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(0) NULL DEFAULT 0 COMMENT '是否删除 0未删除 1已删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_policy_id` (`policy_id`) USING BTREE,
INDEX `idx_metric_id` (`metrics_id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci COMMENT = '监控告警策略指标'
ROW_FORMAT = Dynamic;
-- 通知模板
DROP TABLE IF EXISTS `notify_template`;
CREATE TABLE `notify_template`
(
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '通知名称',
`biz_type` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '业务类型',
`channel_type` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '渠道类型',
`channel_config` json NULL COMMENT '渠道配置',
`message_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '消息模板',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint(0) NULL DEFAULT 0 COMMENT '是否删除 0未删除 1已删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_biz_type` (`biz_type`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci COMMENT = '通知模板'
ROW_FORMAT = Dynamic;sql 脚本 - DML
sql
-- 监控指标
DELETE FROM `monitor_metrics` WHERE id IN (25, 26, 29, 30);
INSERT INTO `monitor_metrics` VALUES (25, '网卡总发送字节大小', 'network', 'net_sent_bytes_total', 'BYTES', '', '网卡总发送字节大小', '2025-08-13 10:36:16', '2025-09-21 01:36:36', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (26, '网卡总接收字节大小', 'network', 'net_recv_bytes_total', 'BYTES', '', '网卡总接收字节大小', '2025-08-13 10:36:16', '2025-09-21 01:36:40', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (29, '网卡每秒发送字节大小', 'network', 'net_sent_bytes_per_second', 'BYTES_S', '', '网卡每秒发送字节大小', '2025-08-13 10:36:16', '2025-09-21 01:37:00', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (30, '网卡每秒接收字节大小', 'network', 'net_recv_bytes_per_second', 'BITS_S', '', '网卡每秒接收字节大小', '2025-08-13 10:36:16', '2025-09-21 01:37:14', 'admin', 'admin', 0);
-- 通知模板
INSERT INTO `notify_template` VALUES (1, '企微', 'ALARM', 'WE_COM', '{\"webhook\": \"https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=你的token\", \"messageType\": \"ALARM\", \"messageClassify\": \"ALARM\"}', '# 🚨 [<font color=@{{ levelColor }}>@{{ level }} @{{ levelLabel }}</font>] @{{ metricsName }}超阈值 \n\n- **主机**: @{{ hostName }} (@{{ hostAddress }}) \n- **指标**: @{{ metricsName }} \n- **条件**: @{{ triggerCondition }} @{{ alarmThreshold }} \n- **当前值**: <font color=@{{ levelColor }}>@{{ alarmValue }}</font> \n- **连续次数**: @{{ consecutiveCount }} \n- **时间**: @{{ alarmTime }} ', '企微通知模板', '2025-09-13 22:47:43', '2025-09-22 15:24:55', 'admin', 'admin', 0);
INSERT INTO `notify_template` VALUES (2, '钉钉', 'ALARM', 'DING', '{\"title\": \"告警通知\", \"secret\": \"你的密钥\", \"webhook\": \"https://oapi.dingtalk.com/robot/send?access_token=你的token\", \"messageType\": \"ALARM\", \"messageClassify\": \"ALARM\"}', '# 🚨 [@{{ level }} @{{ levelLabel }}] @{{ metricsName }}超阈值 \r\n\r\n- **主机**: @{{ hostName }} (@{{ hostAddress }}) \r\n- **指标**: @{{ metricsName }} \r\n- **条件**: @{{ triggerCondition }} @{{ alarmThreshold }} \r\n- **当前值**: @{{ alarmValue }} \r\n- **连续次数**: @{{ consecutiveCount }} \r\n- **时间**: @{{ alarmTime }}', '钉钉通知模板', '2025-09-14 11:29:43', '2025-09-22 15:24:57', 'admin', 'admin', 0);
INSERT INTO `notify_template` VALUES (3, '飞书', 'ALARM', 'FEI_SHU', '{\"secret\": \"你的密钥\", \"webhook\": \"https://open.feishu.cn/open-apis/bot/v2/hook/你的token\", \"messageType\": \"ALARM\", \"messageClassify\": \"ALARM\"}', '🚨 [@{{ level }} @{{ levelLabel }}] @{{ metricsName }} 超阈值\n\n主机: @{{ hostName }} (@{{ hostAddress }})\n指标: @{{ metricsName }}\n条件: @{{ triggerCondition }} @{{ alarmThreshold }}\n当前值: @{{ alarmValue }}\n连续次数: @{{ consecutiveCount }}\n时间: @{{ alarmTime }}', '飞书通知模板', '2025-09-14 11:29:55', '2025-09-22 15:24:59', 'admin', 'admin', 0);
INSERT INTO `notify_template` VALUES (4, '站内信', 'ALARM', 'WEBSITE', '{\"title\": \"告警通知\", \"messageType\": \"ALARM\", \"messageClassify\": \"ALARM\"}', '🚨 [告警通知]\n\n告警等级: <sr>@{{ level }} @{{ levelLabel }}</sr> \n策略名称: <sb>@{{ policyName }}</sb> \n主机: <sb>@{{ hostName }} (@{{ hostAddress }})</sb> \n\n指标: <sb>@{{ metricsName }}</sb> \n条件: @{{ triggerCondition }} @{{ alarmThreshold }} \n当前值: <sr>@{{ alarmValue }}</sr> \n连续次数: @{{ consecutiveCount }} \n时间: @{{ alarmTime }} \n', '站内信通知模板', '2025-09-20 22:52:25', '2025-09-22 15:25:04', 'admin', 'admin', 0);
-- 字典项
DELETE FROM `dict_key` WHERE id IN (78, 86, 87, 88, 89, 90, 92);
INSERT INTO `dict_key` VALUES (78, 'metricsUnit', 'STRING', '[{\"name\": \"alarmUnit\", \"type\": \"STRING\"}]', '监控指标单位', '2025-08-12 23:31:00', '2025-09-15 23:13:26', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (86, 'notifyBizType', 'STRING', '[]', '通知业务类型', '2025-09-13 13:35:03', '2025-09-13 13:35:03', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (87, 'notifyChannelType', 'STRING', '[{\"name\": \"color\", \"type\": \"COLOR\"}, {\"name\": \"notifyType\", \"type\": \"STRING\"}, {\"name\": \"templateTips\", \"type\": \"STRING\"}]', '通知渠道类型', '2025-09-13 13:35:03', '2025-09-20 22:26:20', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (88, 'alarmTriggerCondition', 'STRING', '[]', '告警条件', '2025-09-14 05:36:35', '2025-09-14 05:36:35', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (89, 'alarmLevel', 'INTEGER', '[{\"name\": \"level\", \"type\": \"STRING\"}, {\"name\": \"color\", \"type\": \"STRING\"}]', '告警等级', '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (90, 'alarmEventHandleStatus', 'STRING', '[{\"name\": \"color\", \"type\": \"STRING\"}]', '告警记录处理状态', '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (92, 'falseAlarm', 'INTEGER', '[]', '是否为误报', '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
-- 字典值
DELETE FROM `dict_value` WHERE id IN (217, 221, 298, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542);
DELETE FROM `dict_value` WHERE id >= 575;
INSERT INTO `dict_value` VALUES (217, 2, 'operatorLogType', 'terminal-connect-log:clear', '清理终端连接日志', '{}', 20, '2024-03-04 13:45:07', '2025-09-17 16:20:57', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (221, 2, 'operatorLogType', 'operator-log:clear', '清理操作日志', '{}', 20, '2024-03-04 16:33:31', '2025-09-17 16:20:51', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (298, 44, 'messageClassify', 'TODO', '待办', '{}', 30, '2024-05-13 15:06:27', '2025-09-20 22:36:45', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (533, 78, 'metricsUnit', 'BYTES', '字节', '{\"alarmUnit\": \"MB\"}', 10, '2025-08-12 23:31:00', '2025-09-15 23:15:11', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (534, 78, 'metricsUnit', 'BYTES_S', '字节/秒', '{\"alarmUnit\": \"MB/s\"}', 40, '2025-08-12 23:31:00', '2025-09-15 23:15:04', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (535, 78, 'metricsUnit', 'BITS_S', '比特/秒', '{\"alarmUnit\": \"Mbps\"}', 50, '2025-08-12 23:31:00', '2025-09-15 23:14:51', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (536, 78, 'metricsUnit', 'TEXT', '文本', '{\"alarmUnit\": \"\"}', 100, '2025-08-12 23:31:00', '2025-09-15 23:15:17', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (537, 78, 'metricsUnit', 'NONE', '无', '{\"alarmUnit\": \"\"}', 110, '2025-08-12 23:31:00', '2025-09-15 23:15:23', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (538, 78, 'metricsUnit', 'SECONDS', '秒', '{\"alarmUnit\": \"秒\"}', 30, '2025-08-12 23:55:17', '2025-09-15 23:14:34', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (539, 78, 'metricsUnit', 'COUNT', '次', '{\"alarmUnit\": \"次\"}', 20, '2025-08-13 00:15:15', '2025-09-15 23:14:28', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (540, 78, 'metricsUnit', 'COUNT_S', '次/秒', '{\"alarmUnit\": \"次/秒\"}', 60, '2025-08-13 00:15:38', '2025-09-15 23:14:20', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (541, 78, 'metricsUnit', 'BITS', '比特', '{\"alarmUnit\": \"Mb\"}', 15, '2025-08-13 10:34:27', '2025-09-15 23:14:11', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (542, 78, 'metricsUnit', 'PER', '百分比', '{\"alarmUnit\": \"%\"}', 90, '2025-08-13 10:34:27', '2025-09-15 23:14:08', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (575, 1, 'operatorLogModule', 'infra:notify-template', '通知模板', '{}', 2180, '2025-09-13 13:35:03', '2025-09-21 08:06:38', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (576, 2, 'operatorLogType', 'notify-template:create', '创建通知模板', '{}', 10, '2025-09-13 13:35:03', '2025-09-21 08:06:32', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (577, 2, 'operatorLogType', 'notify-template:update', '更新通知模板', '{}', 20, '2025-09-13 13:35:03', '2025-09-21 08:06:28', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (578, 2, 'operatorLogType', 'notify-template:delete', '删除通知模板', '{}', 30, '2025-09-13 13:35:03', '2025-09-21 08:06:25', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (579, 86, 'notifyBizType', 'ALARM', '告警通知', '{}', 10, '2025-09-13 13:35:03', '2025-09-13 22:02:30', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (580, 87, 'notifyChannelType', 'DING', '钉钉', '{\"color\": \"arcoblue\", \"notifyType\": \"webhook\", \"templateTips\": \"Markdown 格式, 参数请参考文档\"}', 10, '2025-09-13 13:35:03', '2025-09-20 22:54:51', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (581, 87, 'notifyChannelType', 'FEI_SHU', '飞书', '{\"color\": \"arcoblue\", \"notifyType\": \"webhook\", \"templateTips\": \"普通文本格式, 参数请参考文档\"}', 20, '2025-09-13 13:35:03', '2025-09-20 22:54:48', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (582, 87, 'notifyChannelType', 'WE_COM', '企微', '{\"color\": \"arcoblue\", \"notifyType\": \"webhook\", \"templateTips\": \"Markdown 格式, 参数请参考文档\"}', 30, '2025-09-13 13:35:03', '2025-09-20 22:54:43', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (583, 1, 'operatorLogModule', 'monitor:alarm-policy', '监控告警策略', '{}', 2190, '2025-09-13 16:13:49', '2025-09-13 17:03:15', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (584, 2, 'operatorLogType', 'alarm-policy:create', '创建监控告警策略', '{}', 10, '2025-09-13 16:13:49', '2025-09-13 17:03:16', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (585, 2, 'operatorLogType', 'alarm-policy:update', '更新监控告警策略', '{}', 20, '2025-09-13 16:13:49', '2025-09-13 17:03:18', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (586, 2, 'operatorLogType', 'alarm-policy:copy', '复制监控告警策略', '{}', 30, '2025-09-13 16:13:49', '2025-09-13 17:11:16', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (587, 2, 'operatorLogType', 'alarm-policy:delete', '删除监控告警策略', '{}', 40, '2025-09-13 16:13:49', '2025-09-13 17:11:16', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (589, 2, 'operatorLogType', 'alarm-policy:create-rule', '创建监控告警规则', '{}', 50, '2025-09-14 05:36:35', '2025-09-14 06:35:40', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (590, 2, 'operatorLogType', 'alarm-policy:update-rule', '更新监控告警规则', '{}', 60, '2025-09-14 05:36:35', '2025-09-14 06:35:40', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (591, 2, 'operatorLogType', 'alarm-policy:delete-rule', '删除监控告警规则', '{}', 70, '2025-09-14 05:36:35', '2025-09-14 06:35:40', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (592, 88, 'alarmTriggerCondition', 'GT', '>', '{}', 10, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (593, 88, 'alarmTriggerCondition', 'GE', '>=', '{}', 20, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (594, 88, 'alarmTriggerCondition', 'EQ', '==', '{}', 30, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (595, 88, 'alarmTriggerCondition', 'LE', '<=', '{}', 40, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (596, 88, 'alarmTriggerCondition', 'LT', '<', '{}', 50, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (597, 89, 'alarmLevel', '0', '严重', '{\"color\": \"red\", \"level\": \"Critical\"}', 10, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (598, 89, 'alarmLevel', '1', '重要', '{\"color\": \"purple\", \"level\": \"Major\"}', 20, '2025-09-14 05:36:36', '2025-09-21 06:46:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (599, 89, 'alarmLevel', '2', '次要', '{\"color\": \"magenta\", \"level\": \"Minor\"}', 30, '2025-09-14 05:36:36', '2025-09-21 06:45:32', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (600, 89, 'alarmLevel', '3', '警告', '{\"color\": \"orange\", \"level\": \"Warning\"}', 40, '2025-09-14 05:36:36', '2025-09-15 00:54:14', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (601, 89, 'alarmLevel', '4', '信息', '{\"color\": \"gray\", \"level\": \"Info\"}', 50, '2025-09-14 05:36:36', '2025-09-14 05:36:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (602, 2, 'operatorLogType', 'alarm-policy:update-rule-switch', '更新监控告警规则开关', '{}', 80, '2025-09-14 05:36:35', '2025-09-14 06:35:40', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (603, 87, 'notifyChannelType', 'WEBSITE', '站内信', '{\"color\": \"arcoblue\", \"notifyType\": \"website\", \"templateTips\": \"普通文本格式, 文本颜色以及参数请参考文档\"}', 5, '2025-09-13 13:35:03', '2025-09-20 22:54:37', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (604, 1, 'operatorLogModule', 'monitor:alarm-event', '告警记录', '{}', 2200, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (605, 2, 'operatorLogType', 'alarm-event:handle', '处理告警记录', '{}', 10, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (606, 2, 'operatorLogType', 'alarm-event:set-false', '设置告警记录误报', '{}', 20, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (607, 2, 'operatorLogType', 'alarm-event:delete', '删除告警记录', '{}', 30, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (608, 2, 'operatorLogType', 'alarm-event:clear', '清理告警记录', '{}', 40, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (609, 90, 'alarmEventHandleStatus', 'NEW', '新告警', '{\"color\": \"red\"}', 10, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (610, 90, 'alarmEventHandleStatus', 'CONFIRMED', '已确认', '{\"color\": \"orangered\"}', 20, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (611, 90, 'alarmEventHandleStatus', 'RESOLVE', '已解决', '{\"color\": \"green\"}', 30, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (612, 90, 'alarmEventHandleStatus', 'IGNORED', '已忽略', '{\"color\": \"gray\"}', 40, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (615, 92, 'falseAlarm', '1', '误报', '{}', 10, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (616, 92, 'falseAlarm', '0', '非误报', '{}', 20, '2025-09-17 16:20:03', '2025-09-17 16:20:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (617, 44, 'messageClassify', 'ALARM', '告警', '{}', 20, '2025-09-20 22:36:39', '2025-09-20 22:36:39', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (618, 43, 'messageType', 'ALARM', '系统告警', '{\"tagColor\": \"red\", \"tagLabel\": \"告警\", \"tagVisible\": false, \"redirectComponent\": \"alarmEvent\"}', 60, '2025-09-20 22:38:39', '2025-09-21 22:50:57', 'admin', 'admin', 0);
-- 菜单
DELETE FROM `system_menu` WHERE id IN (154, 157, 203);
DELETE FROM `system_menu` WHERE id >= 294;
INSERT INTO `system_menu` VALUES (154, 148, '清理连接日志', 'terminal:terminal-connect-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 13:40:05', '2025-09-17 16:20:21', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (157, 122, '清理操作日志', 'infra:operator-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 17:07:25', '2025-09-17 16:20:25', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (203, 12, '系统设置', NULL, 2, 50, 1, 1, 1, 0, 'IconSettings', NULL, 'systemSetting', '2024-06-17 20:46:15', '2025-09-13 13:34:57', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (294, 282, '主机监控详情', NULL, 2, 11, 0, 1, 1, 0, 'IconComputer', '', 'monitorDetail', '2025-09-03 23:03:20', '2025-09-20 22:11:09', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (295, 12, '通知模板', NULL, 2, 40, 1, 1, 1, 0, 'IconEmail', NULL, 'notifyTemplate', '2025-09-13 13:35:07', '2025-09-21 08:08:13', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (296, 295, '查询通知模板', 'infra:notify-template:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 13:35:07', '2025-09-21 08:09:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (297, 295, '创建通知模板', 'infra:notify-template:create', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 13:35:07', '2025-09-21 08:09:05', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (298, 295, '修改通知模板', 'infra:notify-template:update', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 13:35:07', '2025-09-21 08:09:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (299, 295, '删除通知模板', 'infra:notify-template:delete', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 13:35:07', '2025-09-21 08:09:12', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (300, 282, '告警策略', NULL, 2, 20, 1, 1, 1, 0, 'IconExperiment', NULL, 'alarmPolicy', '2025-09-13 16:13:36', '2025-09-20 22:12:12', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (301, 300, '查询告警策略', 'monitor:alarm-policy:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 16:13:36', '2025-09-13 17:10:59', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (302, 300, '创建告警策略', 'monitor:alarm-policy:create', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 16:13:36', '2025-09-13 17:10:53', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (303, 300, '修改告警策略', 'monitor:alarm-policy:update', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 16:13:36', '2025-09-13 17:10:48', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (304, 300, '复制告警策略', 'monitor:alarm-policy:copy', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 16:13:36', '2025-09-13 17:10:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (305, 300, '删除告警策略', 'monitor:alarm-policy:delete', 3, 50, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-13 16:13:36', '2025-09-13 17:10:41', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (306, 300, '修改告警规则', 'monitor:alarm-policy:update-rule', 3, 60, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-14 14:34:25', '2025-09-14 14:34:25', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (307, 282, '告警规则', NULL, 2, 21, 0, 1, 1, 0, 'IconExperiment', NULL, 'alarmRule', '2025-09-15 00:01:55', '2025-09-20 22:12:16', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (308, 282, '告警记录', NULL, 2, 30, 1, 1, 1, 0, 'IconNotification', NULL, 'alarmEvent', '2025-09-17 16:06:34', '2025-09-20 22:11:32', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (309, 308, '查询告警记录', 'monitor:alarm-event:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-17 16:06:34', '2025-09-17 16:06:34', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (310, 308, '处理告警记录', 'monitor:alarm-event:handle', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-17 16:06:34', '2025-09-17 16:06:34', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (311, 308, '删除告警记录', 'monitor:alarm-event:delete', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-17 16:06:34', '2025-09-17 16:06:34', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (312, 308, '清理告警记录', 'monitor:alarm-event:management:clear', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2025-09-17 16:06:34', '2025-09-17 16:06:34', 'admin', 'admin', 0);