Server Monitor Collector

Server Monitor Collector

Collect server or cloud VM monitoring data, generate formatted Excel reports, and optionally send summaries via email or Feishu/Lark.

Supported Data Sources

Data sources are auto-detected from .env — configure credentials for any combination and they will all be collected.

Setup

1. Configure Environment

Create/edit ~/.hermes/.env. Only configure the sources you need:

# --- Zabbix (pick one auth method) ---
ZABBIX_URL=https://zabbix.example.com/api_jsonrpc.php
ZABBIX_USER=Admin
ZABBIX_PASSWORD=your_password
# ZABBIX_TOKEN=your_api_token  # optional, takes priority over password

# --- Alibaba Cloud ---
ALIBABA_ACCESS_KEY_ID=your_key_id
ALIBABA_ACCESS_KEY_SECRET=your_secret
ALIBABA_REGION=cn-hangzhou
# ALIBABA_METRICS=CPUUtilization,MemoryUtilization,InternetInRate  # optional

# --- Tencent Cloud ---
TENCENT_SECRET_ID=your_secret_id
TENCENT_SECRET_KEY=your_secret_key
TENCENT_REGION=ap-shanghai

# --- Huawei Cloud ---
HUAWEI_ACCESS_KEY=your_access_key
HUAWEI_SECRET_KEY=your_secret_key
HUAWEI_REGION=cn-east-3

# --- Notifications ---
FEISHU_CHAT_ID=oc_xxxx         # optional
SMTP_HOST=smtp.example.com      # optional, omit to skip email
SMTP_PORT=465
SMTP_FROM=alarm@example.com
SMTP_TOKEN=your_token
TARGET_EMAIL=admin@example.com

# --- Report options ---
# TOPN: show top N hosts by memory+CPU score, 0=off (default: 50)
TOPN=50

2. Install Dependencies

Zabbix / Prometheus — no extra deps:

python3 zabbix_cron.py

Alibaba Cloud — needs SDK (use uv since venv has no pip):

uv run --with aliyun-python-sdk-core --with aliyun-python-sdk-cms \
  python3 cloud_monitor.py

Tencent / Huawei — pure Python, only httpx needed:

uv run --with httpx python3 cloud_monitor.py

3. Run Once (Manual Test)

python3 zabbix_cron.py

Expected output:

• ~/.hermes/cron/output/zabbix_monitor.csv
• ~/.hermes/cron/output/zabbix_monitor.xlsx (one sheet per host group + overview + TOP sheet)

4. Schedule Daily Report

hermes cron create \
  --name "Daily Server Health Report" \
  --script zabbix_cron.py \
  --schedule "30 9 * * *"

Output Format

CSV

• UTF-8-BOM encoding — opens correctly in Windows Excel without garbled characters
• Columns: 主机组, 主机名, IP, 内存可用(GB), 内存总量(GB), 内存占用率(%), CPU占用率(%)

XLSX

• 总览 sheet: summary table with host group stats and alarm counts
• Group sheets: one per host group, sorted by memory usage descending
• TOP50(内存+CPU) sheet: top 50 hosts across all groups by combined memory+CPU score
• Cell coloring: 🔴 ≥80% red, 🟠 ≥60% orange, 🟡 ≥40% yellow

Auto-Detection Logic

Scripts detect which sources to use based on which env vars are set:

Zabbix Host Group Exclusion

These groups are excluded by default (set in EXCLUDE_GROUPS in script):

• Templates* — template groups
• Discovered hosts — Zabbix auto-discovery

Key Zabbix Item Keys

Alarm Thresholds

Feishu Message Format

Markdown card sent to FEISHU_CHAT_ID containing:

• Report timestamp, total hosts, group count
• Top 20 hosts with memory ≥60% or CPU ≥60%
• Color-coded: 🔴≥80%, 🟠≥60%, 🟡≥40%

Email Format

• Subject: 服务器监控报告 YYYY-MM-DD HH:MM
• Body: HTML summary matching the Feishu card
• Attachment: zabbix_monitor.xlsx

References

• references/zabbix-config.md — Zabbix API details, item keys, auth options
• references/notification-config.md — Feishu and email SMTP setup, common providers
• references/cloud-config.md — Alibaba / Tencent / Huawei API endpoints, namespaces, SDK usage

Guardrails

• Never hardcode credentials — always use ~/.hermes/.env
• Never print full credentials in logs or chat
• Never place scripts in web-accessible directories
• If Zabbix host has no Agent — memory metrics show N/A, CPU still works
• Alibaba Cloud MemoryUtilization requires Cloud Monitor Agent installed on ECS instance