24 lines
790 B
Plaintext
24 lines
790 B
Plaintext
mysql -uroot -php93000 -D alert_db -e "
|
|
SELECT
|
|
alertname AS 告警名称,
|
|
job AS 监控任务,
|
|
instance AS 实例地址,
|
|
port AS 端口,
|
|
severity AS 告警级别,
|
|
summary AS 告警摘要,
|
|
description AS 详情,
|
|
starts_at AS 触发时间,
|
|
ends_at AS 恢复时间,
|
|
status AS 状态
|
|
FROM alert_log
|
|
WHERE starts_at >= NOW() - INTERVAL 24 HOUR
|
|
ORDER BY starts_at DESC
|
|
INTO OUTFILE '/tmp/告警报表_24h.csv'
|
|
CHARACTER SET utf8mb4
|
|
FIELDS TERMINATED BY ','
|
|
OPTIONALLY ENCLOSED BY '"'
|
|
LINES TERMINATED BY '\n';
|
|
"
|
|
# 手动添加中文表头（避免MySQL导出无表头）
|
|
echo "告警名称,监控任务,实例地址,端口,告警级别,告警摘要,详情,触发时间,恢复时间,状态" > /tmp/告警报表_24h_最终版.csv
|
|
cat /tmp/告警报表_24h.csv >> /tmp/告警报表_24h_最终版.csv |