Dromara Orion Visor

Appearance

v2.5.0 ​

sql 脚本 - DDL - 修改字段精度 ​

sql
-- 修改逻辑删除字段类型
ALTER TABLE dict_key modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE _copy modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE command_snippet modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE data_extra modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE data_group modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE data_group_rel modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE data_permission modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE dict_key modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE dict_value modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_host_log modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_job modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_job_host modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_log modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_template modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE exec_template_host modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE favorite modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE history_value modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE host modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE host_config modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE host_identity modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE host_key modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE operator_log modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE path_bookmark modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE preference modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_menu modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_message modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_role modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_role_menu modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_setting modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_user modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE system_user_role modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE tag modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE tag_rel modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE terminal_connect_log modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE upload_task modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';
ALTER TABLE upload_task_file modify deleted tinyint default 0 NULL COMMENT '是否删除 0未删除 1已删除';

-- 修改时间精度
ALTER TABLE exec_host_log modify start_time DATETIME(6) NULL COMMENT '执行开始时间';
ALTER TABLE exec_host_log modify finish_time DATETIME(6) NULL COMMENT '执行结束时间';
ALTER TABLE exec_log modify start_time DATETIME(6) NULL COMMENT '执行开始时间';
ALTER TABLE exec_log modify finish_time DATETIME(6) NULL COMMENT '执行完成时间';
ALTER TABLE operator_log modify start_time DATETIME(6) NULL COMMENT '开始时间';
ALTER TABLE operator_log modify end_time DATETIME(6) NULL COMMENT '结束时间';
ALTER TABLE terminal_connect_log modify start_time DATETIME(6) NULL COMMENT '开始时间';
ALTER TABLE terminal_connect_log modify end_time DATETIME(6) NULL COMMENT '结束时间';
ALTER TABLE upload_task modify start_time DATETIME(6) NULL COMMENT '开始时间';
ALTER TABLE upload_task modify end_time DATETIME(6) NULL COMMENT '结束时间';
ALTER TABLE upload_task_file modify start_time DATETIME(6) NULL COMMENT '开始时间';
ALTER TABLE upload_task_file modify end_time DATETIME(6) NULL COMMENT '结束时间';

sql 脚本 - DDL - 监控相关表 ​

sql
-- 修改主机表
ALTER TABLE `host` 
ADD COLUMN `agent_key` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'agentKey' AFTER `status`,
ADD COLUMN `agent_version` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '探针版本' AFTER `agent_key`,
ADD COLUMN `agent_install_status` tinyint NULL COMMENT '探针安装状态' AFTER `agent_version`,
ADD COLUMN `agent_online_status` tinyint NULL COMMENT '探针在线状态' AFTER `agent_install_status`,
ADD COLUMN `agent_online_change_time` datetime NULL COMMENT '探针切换在线状态时间' AFTER `agent_online_status`,
ADD INDEX `idx_agent_key`(`agent_key`);

-- 添加主机探针日志表
CREATE TABLE `host_agent_log`
(
    `id`          bigint(0)                                                      NOT NULL AUTO_INCREMENT COMMENT 'id',
    `host_id`     bigint(0)                                                      NULL DEFAULT NULL COMMENT '主机id',
    `agent_key`   char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci      NULL DEFAULT NULL COMMENT 'agentKey',
    `type`        char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci      NULL DEFAULT NULL COMMENT '类型',
    `status`      char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci      NULL DEFAULT NULL COMMENT '状态',
    `message`     varchar(1024) 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_agent_key` (`agent_key`) USING BTREE,
    INDEX `idx_host_id` (`host_id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT = '主机探针日志'
  ROW_FORMAT = Dynamic;
  
-- 添加监控主机表
CREATE TABLE `monitor_host`
(
    `id`             bigint(0)                                                    NOT NULL AUTO_INCREMENT COMMENT 'id',
    `host_id`        bigint(0)                                                    NULL DEFAULT NULL COMMENT '主机id',
    `policy_id`      bigint(0)                                                    NULL DEFAULT NULL COMMENT '策略id',
    `agent_key`      char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci    NULL DEFAULT NULL COMMENT 'agent key',
    `alarm_switch`   tinyint(0)                                                   NULL DEFAULT 0 COMMENT '告警开关',
    `owner_user_id`  bigint(0)                                                    NULL DEFAULT NULL COMMENT '负责人id',
    `owner_username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '负责人用户名',
    `monitor_meta`   json                                                         NULL COMMENT '监控元数据',
    `monitor_config` json                                                         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_policy_id` (`policy_id`) USING BTREE,
    INDEX `idx_agent_key` (`agent_key`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT = '监控主机'
  ROW_FORMAT = Dynamic;

-- 添加监控指标表
CREATE TABLE `monitor_metrics`
(
    `id`          bigint(0)                                                     NOT NULL AUTO_INCREMENT COMMENT 'id',
    `name`        varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NULL DEFAULT NULL COMMENT '指标名称',
    `measurement` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NULL DEFAULT NULL COMMENT '数据集',
    `value`       varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '指标项',
    `unit`        char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci      NULL DEFAULT 'NONE' COMMENT '单位',
    `suffix`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NULL DEFAULT NULL COMMENT '后缀',
    `description` varchar(128) 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_value` (`value`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT = '监控指标'
  ROW_FORMAT = Dynamic;

sql 脚本 - DML ​

sql
-- 修改字段名称
UPDATE data_extra
SET value = JSON_MERGE_PATCH(
    JSON_REMOVE(value, '$.cpuCore', '$.publicIpAddress', '$.privateIpAddress', '$.chargePerson'),
    JSON_OBJECT(
        'cpuPhysicalCore', value->'$.cpuCore',
        'publicIpAddresses', value->'$.publicIpAddress',
        'privateIpAddresses', value->'$.privateIpAddress',
        'ownerPerson', value->'$.chargePerson'
    )
)
WHERE type = 'HOST' AND item = 'SPEC';

-- 初始化主机表
update host set agent_key = REPLACE(UUID(),'-',''), agent_install_status = '0';

-- 添加指标
INSERT INTO `monitor_metrics` VALUES (1, 'CPU用户利用率', 'cpu', 'cpu_user_seconds_total', 'PER', NULL, '用户态使用时间', '2025-08-12 23:51:16', '2025-09-06 17:09:02', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (2, 'CPU系统利用率', 'cpu', 'cpu_system_seconds_total', 'PER', NULL, '内核态使用时间', '2025-08-13 00:23:56', '2025-09-06 17:09:02', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (3, 'CPU总利用率', 'cpu', 'cpu_total_seconds_total', 'PER', NULL, '用户态使用时间+内核态使用时间', '2025-08-13 00:24:30', '2025-09-06 17:09:02', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (4, '内存使用量', 'memory', 'mem_used_bytes_total', 'BYTES', NULL, '内存使用字节数', '2025-08-13 00:28:33', '2025-09-07 11:56:25', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (5, '内存使用率', 'memory', 'mem_used_percent', 'PER', NULL, '内存使用率', '2025-08-13 00:30:02', '2025-09-06 17:09:03', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (6, '交换内存使用量', 'memory', 'mem_swap_used_bytes_total', 'BYTES', NULL, '交换区使用字节数', '2025-08-13 00:31:14', '2025-09-07 11:56:21', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (7, '交换内存使用率', 'memory', 'mem_swap_used_percent', 'PER', NULL, '交换区使用率', '2025-08-13 00:31:48', '2025-09-06 17:09:03', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (8, '系统负载-1', 'load', 'load1', 'NONE', NULL, 'load1', '2025-08-13 00:33:01', '2025-08-13 00:33:01', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (9, '系统负载-5', 'load', 'load5', 'NONE', NULL, 'load5', '2025-08-13 00:33:24', '2025-08-13 00:33:24', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (10, '系统负载-15', 'load', 'load15', 'NONE', NULL, 'load15', '2025-08-13 00:33:45', '2025-08-13 00:33:45', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (11, '系统负载比-1', 'load', 'load1_core_ratio', 'NONE', NULL, '每个核心的平均load1 ', '2025-08-13 00:34:41', '2025-08-13 10:50:05', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (12, '系统负载比-5', 'load', 'load5_core_ratio', 'NONE', NULL, '每个核心的平均load5', '2025-08-13 00:35:12', '2025-08-13 10:50:05', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (13, '系统负载比-15', 'load', 'load15_core_ratio', 'NONE', NULL, '每个核心的平均load15', '2025-08-13 00:35:38', '2025-08-13 10:50:05', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (14, '磁盘使用量', 'disk', 'disk_fs_used_bytes', 'BYTES', NULL, '磁盘使用量', '2025-08-13 10:04:18', '2025-08-13 10:04:18', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (15, '磁盘使用率', 'disk', 'disk_fs_used_percent', 'PER', NULL, '磁盘使用率', '2025-08-13 10:04:18', '2025-09-06 17:09:03', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (16, 'inode使用率', 'disk', 'disk_fs_inodes_used_percent', 'PER', NULL, '磁盘inode使用率', '2025-08-13 10:04:18', '2025-09-06 17:09:03', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (17, 'IO总读取字节大小', 'io', 'disk_io_read_bytes_total', 'BYTES', NULL, '磁盘IO总读取字节大小', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (18, 'IO总写入字节大小', 'io', 'disk_io_write_bytes_total', 'BYTES', NULL, '磁盘IO总写入字节大小', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (19, 'IO总读取次数', 'io', 'disk_io_reads_total', 'COUNT', NULL, '磁盘IO总读取次数', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (20, 'IO总写入次数', 'io', 'disk_io_writes_total', 'COUNT', NULL, '磁盘IO总写入次数', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (21, 'IO每秒读取字节大小', 'io', 'disk_io_read_bytes_per_second', 'BYTES_S', NULL, '磁盘IO每秒读取字节大小', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (22, 'IO每秒写入字节大小', 'io', 'disk_io_write_bytes_per_second', 'BYTES_S', NULL, '磁盘IO每秒写入字节大小', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (23, 'IO每秒读取次数', 'io', 'disk_io_reads_per_second', 'COUNT_S', NULL, '磁盘IO每秒读取次数', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (24, 'IO每秒写入次数', 'io', 'disk_io_writes_per_second', 'COUNT_S', NULL, '磁盘IO每秒写入次数', '2025-08-13 10:10:29', '2025-08-13 10:10:29', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (25, '网卡总发送字节大小', 'network', 'net_recv_bytes_total', 'BITS', NULL, '网卡总发送字节大小', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (26, '网卡总接收字节大小', 'network', 'net_recv_bytes_total', 'BITS', NULL, '网卡总接收字节大小', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (27, '网卡总发送包数量', 'network', 'net_sent_packets_total', 'COUNT', NULL, '网卡总发送包数量', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (28, '网卡总接收包数量', 'network', 'net_recv_packets_total', 'COUNT', NULL, '网卡总接收包数量', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (29, '网卡每秒发送字节大小', 'network', 'net_sent_bytes_per_second', 'BITS_S', NULL, '网卡每秒发送字节大小', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (30, '网卡每秒接收字节大小', 'network', 'net_recv_bytes_per_second', 'BITS_S', NULL, '网卡每秒接收字节大小', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (31, '网卡每秒发送包数量', 'network', 'net_sent_packets_per_second', 'COUNT_S', NULL, '网卡每秒发送包数量', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (32, '网卡每秒接收包数量', 'network', 'net_recv_packets_per_second', 'COUNT_S', NULL, '网卡每秒接收包数量', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (33, 'TCP连接数', 'connections', 'net_tcp_connections', 'NONE', NULL, 'TCP连接数', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (34, 'UDP连接数', 'connections', 'net_udp_connections', 'NONE', NULL, 'UDP连接数', '2025-08-13 10:36:16', '2025-08-13 10:36:16', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (35, 'INET连接数', 'connections', 'net_inet_connections', 'NONE', NULL, 'INET连接数', '2025-08-13 10:36:17', '2025-08-13 10:36:17', 'admin', 'admin', 0);
INSERT INTO `monitor_metrics` VALUES (36, '总连接数', 'connections', 'net_all_connections', 'NONE', NULL, 'TCP + UDP + INET 连接数量', '2025-08-13 10:36:17', '2025-08-13 10:36:17', 'admin', 'admin', 0);

-- 添加菜单数据
DELETE FROM `system_menu` WHERE id IN (282,283,284,285,286,287,288,289,290,292,293,294);
INSERT INTO `system_menu` VALUES (282, 0, '系统监控', NULL, 1, 350, 1, 1, 1, 0, 'IconComputer', NULL, 'monitorModule', '2025-08-12 23:31:02', '2025-08-12 23:38:49', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (283, 282, '监控指标', NULL, 2, 110, 1, 1, 1, 0, 'IconList', NULL, 'metrics', '2025-08-12 23:31:02', '2025-09-03 23:03:30', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (284, 283, '查询监控指标', 'monitor:monitor-metrics:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-12 23:31:02', '2025-08-12 23:31:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (285, 283, '创建监控指标', 'monitor:monitor-metrics:create', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-12 23:31:02', '2025-08-12 23:31:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (286, 283, '修改监控指标', 'monitor:monitor-metrics:update', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-12 23:31:02', '2025-08-12 23:31:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (287, 283, '删除监控指标', 'monitor:monitor-metrics:delete', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-12 23:31:02', '2025-08-12 23:31:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (288, 282, '主机监控', NULL, 2, 10, 1, 1, 1, 0, 'IconComputer', NULL, 'monitorHost', '2025-08-23 17:02:02', '2025-08-24 22:47:03', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (289, 288, '查询监控主机', 'monitor:monitor-host:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-23 17:02:02', '2025-08-23 17:02:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (290, 288, '修改监控主机', 'monitor:monitor-host:update', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-23 17:02:02', '2025-08-23 17:03:56', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (292, 288, '修改告警开关', 'monitor:monitor-host:update-switch', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-23 17:02:02', '2025-08-23 17:04:31', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (293, 64, '安装探针', 'asset:host:install-agent', 3, 110, 1, 1, 1, 0, NULL, NULL, NULL, '2025-08-31 20:18:14', '2025-08-31 20:18:14', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (294, 282, '主机监控详情', NULL, 2, 20, 0, 1, 1, 0, 'IconComputer', '', 'monitorDetail', '2025-09-03 23:03:20', '2025-09-03 23:03:55', 'admin', 'admin', 0);

-- 添加字典项
DELETE FROM `dict_key` WHERE id IN (77,78,79,80,81,82,83,84,85);
INSERT INTO `dict_key` VALUES (77, 'metricsMeasurement', 'STRING', '[]', '监控指标类型', '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (78, 'metricsUnit', 'STRING', '[]', '监控指标单位', '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (79, 'monitorAlarmSwitch', 'INTEGER', '[]', '监控告警开关', '2025-08-23 17:07:21', '2025-09-01 23:32:34', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (80, 'agentOnlineStatus', 'INTEGER', '[{\"name\": \"status\", \"type\": \"STRING\"}, {\"name\": \"color\", \"type\": \"COLOR\"}, {\"name\": \"icon\", \"type\": \"STRING\"}]', '探针在线状态', '2025-08-23 17:07:21', '2025-08-27 07:48:53', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (81, 'agentInstallStatus', 'INTEGER', '[]', '探针安装状态', '2025-08-24 22:48:54', '2025-08-27 07:48:17', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (82, 'agentLogType', 'STRING', '[]', '探针日志类型', '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (83, 'agentLogStatus', 'STRING', '[{\"name\": \"color\", \"type\": \"STRING\"}, {\"name\": \"loading\", \"type\": \"BOOLEAN\"}, {\"name\": \"installLabel\", \"type\": \"STRING\"}]', '探针日志状态', '2025-08-31 12:16:24', '2025-09-01 23:18:18', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (84, 'metricsChartRange', 'STRING', '[{\"name\": \"window\", \"type\": \"STRING\"}]', '指标图表区间', '2025-09-06 23:32:21', '2025-09-06 23:32:21', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (85, 'metricsAggregate', 'STRING', '[]', '指标聚合函数', '2025-09-07 16:54:22', '2025-09-07 16:54:22', 'admin', 'admin', 0);

-- 添加字典值
DELETE FROM `dict_value` WHERE id IN (388,389,390,391,392,393,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574);
INSERT INTO `dict_value` VALUES (388, 2, 'operatorLogType', 'terminal:sftp-chown', '修改文件归属', '{}', 73, '2024-02-23 17:54:37', '2024-10-16 10:41:59', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (389, 2, 'operatorLogType', 'terminal:sftp-chgrp', '修改文件分组', '{}', 76, '2024-02-23 17:54:37', '2024-10-16 10:41:59', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (390, 2, 'operatorLogType', 'terminal:sftp-get-content', '查看文件内容', '{}', 79, '2024-02-23 17:54:37', '2024-10-16 10:41:59', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (391, 33, 'terminalFileOperatorType', 'terminal:sftp-chown', '修改文件归属', '{}', 63, '2024-03-05 16:52:18', '2025-06-29 12:30:54', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (392, 33, 'terminalFileOperatorType', 'terminal:sftp-chgrp', '修改文件分组', '{}', 66, '2024-03-05 16:52:18', '2025-06-29 12:30:55', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (393, 33, 'terminalFileOperatorType', 'terminal:sftp-get-content', '查看文件内容', '{}', 69, '2024-03-05 16:52:18', '2025-06-29 12:30:55', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (522, 1, 'operatorLogModule', 'monitor:monitor-metrics', '监控指标', '{}', 2160, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (523, 2, 'operatorLogType', 'monitor-metrics:create', '创建监控指标', '{}', 10, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (524, 2, 'operatorLogType', 'monitor-metrics:update', '更新监控指标', '{}', 20, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (525, 2, 'operatorLogType', 'monitor-metrics:delete', '删除监控指标', '{}', 30, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (526, 77, 'metricsMeasurement', 'cpu', 'cpu', '{}', 10, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (527, 77, 'metricsMeasurement', 'memory', '内存', '{}', 20, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (528, 77, 'metricsMeasurement', 'load', '负载', '{}', 30, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (529, 77, 'metricsMeasurement', 'disk', '磁盘', '{}', 40, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (530, 77, 'metricsMeasurement', 'io', 'io', '{}', 50, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (531, 77, 'metricsMeasurement', 'network', '网络', '{}', 60, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (532, 77, 'metricsMeasurement', 'connections', '连接数', '{}', 70, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (533, 78, 'metricsUnit', 'BYTES', '字节', '{}', 10, '2025-08-12 23:31:00', '2025-08-12 23:31:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (534, 78, 'metricsUnit', 'BYTES_S', '字节/秒', '{}', 40, '2025-08-12 23:31:00', '2025-08-13 00:17:12', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (535, 78, 'metricsUnit', 'BITS_S', '比特/秒', '{}', 50, '2025-08-12 23:31:00', '2025-08-13 00:17:14', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (536, 78, 'metricsUnit', 'TEXT', '文本', '{}', 100, '2025-08-12 23:31:00', '2025-08-15 16:38:56', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (537, 78, 'metricsUnit', 'NONE', '无', '{}', 110, '2025-08-12 23:31:00', '2025-08-15 16:38:56', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (538, 78, 'metricsUnit', 'SECONDS', '秒', '{}', 30, '2025-08-12 23:55:17', '2025-08-13 00:17:07', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (539, 78, 'metricsUnit', 'COUNT', '次', '{}', 20, '2025-08-13 00:15:15', '2025-08-13 00:15:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (540, 78, 'metricsUnit', 'COUNT_S', '次/秒', '{}', 60, '2025-08-13 00:15:38', '2025-08-13 00:17:20', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (541, 78, 'metricsUnit', 'BITS', '比特', '{}', 15, '2025-08-13 10:34:27', '2025-08-13 10:34:27', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (542, 78, 'metricsUnit', 'PER', '百分比', '{}', 90, '2025-08-13 10:34:27', '2025-08-13 10:34:27', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (543, 79, 'monitorAlarmSwitch', '0', '关闭', '{}', 10, '2025-08-23 17:07:21', '2025-09-01 23:32:55', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (544, 79, 'monitorAlarmSwitch', '1', '开启', '{}', 20, '2025-08-23 17:07:21', '2025-09-01 23:32:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (545, 80, 'agentOnlineStatus', '0', '离线', '{\"icon\": \"icon-close\", \"color\": \"red\", \"status\": \"error\"}', 10, '2025-08-23 17:07:21', '2025-08-27 07:48:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (546, 80, 'agentOnlineStatus', '1', '在线', '{\"icon\": \"icon-check\", \"color\": \"green\", \"status\": \"pass\"}', 20, '2025-08-23 17:07:21', '2025-08-27 07:48:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (547, 1, 'operatorLogModule', 'monitor:monitor-host', '监控主机', '{}', 2170, '2025-08-23 17:08:17', '2025-08-23 17:08:17', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (548, 2, 'operatorLogType', 'monitor-host:update', '更新监控配置', '{}', 10, '2025-08-23 17:08:17', '2025-08-23 17:08:17', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (549, 2, 'operatorLogType', 'monitor-host:update-switch', '更新监控开关', '{}', 20, '2025-08-23 17:08:17', '2025-08-23 17:08:17', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (550, 81, 'agentInstallStatus', '0', '未安装', '{}', 10, '2025-08-24 22:49:27', '2025-08-27 07:48:12', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (551, 81, 'agentInstallStatus', '1', '已安装', '{}', 20, '2025-08-24 22:49:34', '2025-08-27 07:48:12', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (553, 82, 'agentLogType', 'OFFLINE', '下线', '{}', 10, '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (554, 82, 'agentLogType', 'ONLINE', '上线', '{}', 20, '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (555, 82, 'agentLogType', 'INSTALL', '安装', '{}', 30, '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (556, 82, 'agentLogType', 'START', '启动', '{}', 40, '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (557, 82, 'agentLogType', 'STOP', '停止', '{}', 50, '2025-08-31 12:16:24', '2025-08-31 12:16:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (558, 83, 'agentLogStatus', 'WAIT', '等待中', '{\"color\": \"green\", \"loading\": true, \"installLabel\": \"等待安装\"}', 10, '2025-08-31 12:16:24', '2025-09-01 23:18:53', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (559, 83, 'agentLogStatus', 'RUNNING', '运行中', '{\"color\": \"green\", \"loading\": true, \"installLabel\": \"安装中\"}', 20, '2025-08-31 12:16:24', '2025-09-01 23:18:48', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (560, 83, 'agentLogStatus', 'SUCCESS', '成功', '{\"color\": \"arcoblue\", \"loading\": false, \"installLabel\": \"安装成功\"}', 30, '2025-08-31 12:16:24', '2025-09-01 23:18:41', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (561, 83, 'agentLogStatus', 'FAILED', '失败', '{\"color\": \"red\", \"loading\": false, \"installLabel\": \"安装失败\"}', 40, '2025-08-31 12:16:24', '2025-09-01 23:18:36', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (562, 2, 'operatorLogType', 'host:install-agent', '安装主机探针', '{}', 110, '2025-08-31 20:18:44', '2025-08-31 20:18:44', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (563, 2, 'operatorLogType', 'host:update-install-status', '修改探针安装状态', '{}', 120, '2025-08-31 20:18:44', '2025-08-31 20:18:44', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (564, 2, 'operatorLogType', 'host:upload-agent-release', '上传探针发布包', '{}', 130, '2025-08-31 20:18:44', '2025-09-02 07:21:42', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (565, 84, 'metricsChartRange', '-30m', '30分钟', '{\"window\": \"1m\"}', 10, '2025-09-06 23:33:13', '2025-09-07 01:45:01', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (566, 84, 'metricsChartRange', '-2h', '2小时', '{\"window\": \"1m,5m\"}', 20, '2025-09-06 23:33:49', '2025-09-07 01:44:55', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (567, 84, 'metricsChartRange', '-24h', '24小时', '{\"window\": \"5m,1h\"}', 30, '2025-09-06 23:34:28', '2025-09-07 01:44:48', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (568, 84, 'metricsChartRange', '-7d', '1周', '{\"window\": \"1h,12h,24h\"}', 40, '2025-09-06 23:35:37', '2025-09-07 01:44:43', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (569, 84, 'metricsChartRange', '-30d', '30天', '{\"window\": \"1d\"}', 50, '2025-09-06 23:36:17', '2025-09-07 01:44:38', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (570, 84, 'metricsChartRange', '-60d', '60天', '{\"window\": \"1d\"}', 60, '2025-09-06 23:36:31', '2025-09-07 01:44:35', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (571, 85, 'metricsAggregate', 'mean', '平均值', '{}', 10, '2025-09-07 16:54:35', '2025-09-07 16:54:35', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (572, 85, 'metricsAggregate', 'max', '最大值', '{}', 20, '2025-09-07 16:54:41', '2025-09-07 16:54:59', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (573, 85, 'metricsAggregate', 'min', '最小值', '{}', 30, '2025-09-07 16:55:19', '2025-09-07 16:55:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (574, 85, 'metricsAggregate', 'sum', '总和', '{}', 40, '2025-09-07 16:55:27', '2025-09-07 16:55:27', 'admin', 'admin', 0);

最后更新: