โ† Back to Skills Marketplace
onlyloveher

Ioc Patrol Report

by onlyloveher ยท GitHub โ†— ยท v1.0.1 ยท MIT-0
cross-platform โš  suspicious
116
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install ioc-patrol-report-cn
Description
๐Ÿข IOCๆ™บ่ƒฝ่ฟ็ปดๆŠฅๅ‘Š็”Ÿๆˆๅ™จ - ไธบๆ™บ่ƒฝๅปบ็ญ‘/ๅ›ญๅŒบ่‡ชๅŠจ็”Ÿๆˆไธ“ไธšๅทกๆฃ€ๆŠฅๅ‘Šใ€‚ๅˆ†ๆž่ฎพๅค‡็Šถๆ€ใ€ๆŠฅ่ญฆ่ฎฐๅฝ•ใ€่ƒฝ่€—ๆ•ฐๆฎใ€ๅทฅๅ•่ฟ›ๅบฆ๏ผŒ็”Ÿๆˆๆ—ฅๆŠฅ/ๅ‘จๆŠฅใ€‚ๆ”ฏๆŒPostgreSQLๆ•ฐๆฎๅบ“่ฟžๆŽฅ๏ผŒ่พ“ๅ‡บMarkdown/HTMLๆ ผๅผใ€‚้€‚็”จไบŽ็‰ฉไธš็ฎก็†ใ€ๅ•†ไธš็ปผๅˆไฝ“ใ€ๅทฅไธšๅ›ญๅŒบใ€ๅŒป้™ขๅญฆๆ ก็ญ‰ๆ™บ่ƒฝๅปบ็ญ‘่ฟ็ปดๅœบๆ™ฏใ€‚
README (SKILL.md)

๐Ÿข IOC ๆ™บ่ƒฝๅทกๆฃ€ๆŠฅๅ‘Š

ไธบๆ™บ่ƒฝๅปบ็ญ‘/ๅ›ญๅŒบ่‡ชๅŠจ็”Ÿๆˆไธ“ไธšๅทกๆฃ€ๆŠฅๅ‘Š


โœจ ๆ ธๅฟƒๅŠŸ่ƒฝ

ๅŠŸ่ƒฝๆจกๅ— ๆ่ฟฐ
๐Ÿ“Š ่ฎพๅค‡็Šถๆ€ๅทกๆฃ€ ๅˆ†ๆž่ฎพๅค‡ๅœจ็บฟ็އใ€ๆ•…้šœๅˆ†ๅธƒใ€่ฟ่กŒ็Šถๆ€
๐Ÿšจ ๆŠฅ่ญฆๅค„็†ๅˆ†ๆž ็ปŸ่ฎกๆŠฅ่ญฆๆ•ฐ้‡ใ€ๅ“ๅบ”ๆ—ถ้•ฟใ€ๅค„็†็އใ€้‡ๅคๆŠฅ่ญฆ
โšก ่ƒฝ่€—ๆ•ฐๆฎๅˆ†ๆž ๅฏนๆฏ”ๆ˜จๆ—ฅ/ไธŠๅ‘จ่ƒฝ่€—๏ผŒ่ฏ†ๅˆซๅผ‚ๅธธ็”จ่ƒฝ็‚น
๐Ÿ“ ๅทฅๅ•่ฟ›ๅบฆ่ฟฝ่ธช ็ปŸ่ฎกๅทฅๅ•ๅฎŒๆˆ็އใ€SLA่พพๆˆๆƒ…ๅ†ตใ€็งฏๅŽ‹ๆƒ…ๅ†ต
๐Ÿ’ก ๆ™บ่ƒฝๅปบ่ฎฎ็”Ÿๆˆ ๅŸบไบŽๆ•ฐๆฎ่‡ชๅŠจ็”Ÿๆˆ่ฟ็ปดไผ˜ๅŒ–ๅปบ่ฎฎ

๐Ÿš€ ๅฟซ้€Ÿๅผ€ๅง‹

ๅฎ‰่ฃ…

clawhub install ioc-patrol-report

้…็ฝฎๆ•ฐๆฎๆบ

็ผ–่พ‘ ~/.openclaw/skills/ioc-patrol-report/config.yaml๏ผš

database:
  host: localhost
  port: 5432
  name: ioc_db
  user: admin
  password: ${DB_PASSWORD}  # ๅปบ่ฎฎไฝฟ็”จ็Žฏๅขƒๅ˜้‡

tables:
  devices: devices          # ่ฎพๅค‡่กจ
  alarms: alarms            # ๆŠฅ่ญฆ่กจ
  work_orders: work_orders  # ๅทฅๅ•่กจ
  energy: energy_records    # ่ƒฝ่€—่กจ

report:
  company_name: "XX็‰ฉไธš็ฎก็†ๆœ‰้™ๅ…ฌๅธ"
  project_name: "XXๅ•†ไธš็ปผๅˆไฝ“"
  output_dir: "./reports"

็”ŸๆˆๆŠฅๅ‘Š

# ็”ŸๆˆไปŠๆ—ฅๅทกๆฃ€ๆŠฅๅ‘Š
cd skills/ioc-patrol-report
uv run scripts/generate_report.py --type daily

# ็”ŸๆˆๆŒ‡ๅฎšๆ—ฅๆœŸๆŠฅๅ‘Š
uv run scripts/generate_report.py --type daily --date 2026-03-20

# ็”Ÿๆˆๆœฌๅ‘จๅทกๆฃ€ๆŠฅๅ‘Š
uv run scripts/generate_report.py --type weekly --week 2026-W12

๐Ÿ“‹ ๆŠฅๅ‘Š็คบไพ‹

ๆ—ฅๆŠฅ่พ“ๅ‡บๆ ผๅผ

# ๐Ÿ“Š IOCๆ™บ่ƒฝๅทกๆฃ€ๆ—ฅๆŠฅ - 2026-03-20

## ไธ€ใ€่ฎพๅค‡็Šถๆ€ๆ€ป่งˆ

| ็ฑปๅž‹ | ๆ€ปๆ•ฐ | ๅœจ็บฟ | ็ฆป็บฟ | ๆ•…้šœ | ๅœจ็บฟ็އ |
|------|------|------|------|------|--------|
| ็ฉบ่ฐƒ | 128 | 125 | 2 | 1 | 97.7% |
| ็…งๆ˜Ž | 356 | 354 | 2 | 0 | 99.4% |
| ็”ตๆขฏ | 24 | 24 | 0 | 0 | 100% |
| ๆถˆ้˜ฒ | 89 | 89 | 0 | 0 | 100% |

## ไบŒใ€ๆŠฅ่ญฆๅค„็†ๆƒ…ๅ†ต

- ไปŠๆ—ฅๆŠฅ่ญฆๆ€ปๆ•ฐ๏ผš23 ๆก
- ๅทฒๅค„็†๏ผš21 ๆก
- ๅค„็†ไธญ๏ผš2 ๆก
- ๅนณๅ‡ๅ“ๅบ”ๆ—ถ้—ด๏ผš8.5 ๅˆ†้’Ÿ
- ๅค„็†็އ๏ผš91.3%

### ้‡็‚นๅ…ณๆณจๆŠฅ่ญฆ
1. ๐Ÿ”ด 3F-็ฉบ่ฐƒๆœบ็ป„Aๅผ‚ๅธธ๏ผˆๅค„็†ไธญ๏ผ‰
2. ๐ŸŸก ๅœฐไธ‹ๅฎค็…งๆ˜Žๅ›ž่ทฏๆ•…้šœ๏ผˆๅทฒๅค„็†๏ผ‰

## ไธ‰ใ€่ƒฝ่€—ๅˆ†ๆž

| ่ƒฝๆบ็ฑปๅž‹ | ไปŠๆ—ฅ็”จ้‡ | ๆ˜จๆ—ฅ็”จ้‡ | ็Žฏๆฏ” |
|----------|----------|----------|------|
| ็”ต(kWh) | 12,345 | 12,100 | +2.0% |
| ๆฐด(mยณ) | 456 | 480 | -5.0% |
| ๅคฉ็„ถๆฐ”(mยณ) | 123 | 130 | -5.4% |

## ๅ››ใ€ๅทฅๅ•่ฟ›ๅบฆ

- ๆ–ฐๅขžๅทฅๅ•๏ผš5 ไธช
- ๅทฒๅฎŒๆˆ๏ผš4 ไธช
- ่ฟ›่กŒไธญ๏ผš3 ไธช
- SLA่พพๆˆ็އ๏ผš92%

## ไบ”ใ€่ฟ็ปดๅปบ่ฎฎ

1. โš ๏ธ 3F็ฉบ่ฐƒๆœบ็ป„้œ€้‡็‚นๅ…ณๆณจ๏ผŒๅปบ่ฎฎๅฎ‰ๆŽ’ๆฃ€ไฟฎ
2. โœ… ่ƒฝ่€—ๆ•ดไฝ“ๅนณ็จณ๏ผŒ็”จๆฐด้‡ๆŒ็ปญไธ‹้™๏ผŒ่Š‚ๆฐดๆŽชๆ–ฝ่งๆ•ˆ
3. ๐Ÿ“ ๅปบ่ฎฎๅขžๅŠ ๅœฐไธ‹ๅฎค็…งๆ˜Žๅทกๆฃ€้ข‘ๆฌก

---
*ๆŠฅๅ‘Š็”Ÿๆˆๆ—ถ้—ด๏ผš2026-03-20 08:00*
*IOCๆ™บ่ƒฝ่ฟ็ปด็ณป็ปŸ*

๐Ÿ“– ไฝฟ็”จๆกˆไพ‹

ๆกˆไพ‹1๏ผšๅ•†ไธš็ปผๅˆไฝ“ๆ—ฅๅธธๅทกๆฃ€

ๅœบๆ™ฏ๏ผšๆŸๅ•†ไธš็ปผๅˆไฝ“็‰ฉไธšๆฏๅคฉ้œ€่ฆ็”Ÿๆˆๅทกๆฃ€ๆŠฅๅ‘Š

้…็ฝฎ๏ผš

report:
  company_name: "XX็‰ฉไธš็ฎก็†ๅ…ฌๅธ"
  project_name: "XX่ดญ็‰ฉไธญๅฟƒ"

ๅฎšๆ—ถไปปๅŠก๏ผš

# crontab -e
0 8 * * * cd /root/clawd/skills/ioc-patrol-report && uv run scripts/generate_report.py --type daily

ๆกˆไพ‹2๏ผšๅทฅไธšๅ›ญๅŒบๅ‘จๆŠฅๆฑ‡ๆ€ป

ๅœบๆ™ฏ๏ผšๅทฅไธšๅ›ญๅŒบๆฏๅ‘จๆฑ‡ๆ€ป่ฟ็ปดๆ•ฐๆฎ

้…็ฝฎ๏ผš

report:
  company_name: "XXๅทฅไธšๅ›ญๅŒบ"
  project_name: "AๅŒบๅŽ‚ๆˆฟ"
  weekly_summary: true

ๆ‰ง่กŒ๏ผš

# ๆฏๅ‘จไธ€ๆ—ฉ8็‚น็”Ÿๆˆ
0 8 * * 1 uv run scripts/generate_report.py --type weekly

ๆกˆไพ‹3๏ผšๅŒป้™ขๆ™บ่ƒฝ่ฟ็ปด

ๅœบๆ™ฏ๏ผšๅŒป้™ขๅŽๅ‹ค้ƒจ้—จ้œ€่ฆ้‡็‚นๅ…ณๆณจ่ฎพๅค‡่ฟ่กŒ

่‡ชๅฎšไน‰้…็ฝฎ๏ผš

priority_devices:
  - type: "ๅŒป็”จๆฐ”ไฝ“"
    alert_threshold: 99.9%  # ๅฏ็”จๆ€ง่ฆๆฑ‚
  - type: "ๅ‡€ๅŒ–็ฉบ่ฐƒ"
    alert_threshold: 99%
  - type: "็”ตๆขฏ"
    alert_threshold: 99.5%

ๆกˆไพ‹4๏ผšๆ•ฐๆฎไธญๅฟƒๅทกๆฃ€

ๅœบๆ™ฏ๏ผšๆ•ฐๆฎไธญๅฟƒ้œ€่ฆไธฅๆ ผ็›‘ๆŽงๆธฉๆนฟๅบฆๅ’Œ็”ตๅŠ›

่‡ชๅฎšไน‰ๆŒ‡ๆ ‡๏ผš

custom_metrics:
  temperature:
    range: [18, 27]  # ๅˆ่ง„่Œƒๅ›ด
    alert_deviation: 2  # ๅๅทฎๅ‘Š่ญฆ้˜ˆๅ€ผ
  humidity:
    range: [40, 60]
  ups_load:
    max: 80%  # ่ดŸ่ฝฝไธŠ้™

โš™๏ธ ้ซ˜็บง้…็ฝฎ

่‡ชๅฎšไน‰ๆŠฅๅ‘Šๆจกๆฟ

็ผ–่พ‘ assets/report-template.md๏ผš

# {{company_name}} ๅทกๆฃ€ๆŠฅๅ‘Š

## {{project_name}} - {{date}}

{% for section in sections %}
{{ section.content }}
{% endfor %}

่‡ชๅฎšไน‰ๅˆ†ๆž่ง„ๅˆ™

็ผ–่พ‘ scripts/analyze.py๏ผš

def custom_kpi(df):
    """่‡ชๅฎšไน‰KPI่ฎก็ฎ—"""
    return {
        'availability': df['online'] / df['total'],
        'efficiency': df['output'] / df['input']
    }

def anomaly_detection(df):
    """่ƒฝ่€—ๅผ‚ๅธธๆฃ€ๆต‹"""
    threshold = df['value'].mean() * 1.5
    return df[df['value'] > threshold]

๐Ÿ“ ็›ฎๅฝ•็ป“ๆž„

ioc-patrol-report/
โ”œโ”€โ”€ SKILL.md              # ๆœฌๆ–‡ๆกฃ
โ”œโ”€โ”€ package.json          # ๆŠ€่ƒฝ้…็ฝฎ
โ”œโ”€โ”€ config.yaml           # ๆ•ฐๆฎๆบ้…็ฝฎ
โ”œโ”€โ”€ scripts/
โ”‚   โ”œโ”€โ”€ generate_report.py  # ไธป็จ‹ๅบ
โ”‚   โ”œโ”€โ”€ analyze.py          # ๅˆ†ๆžๆจกๅ—
โ”‚   โ””โ”€โ”€ db_connector.py     # ๆ•ฐๆฎๅบ“่ฟžๆŽฅ
โ”œโ”€โ”€ assets/
โ”‚   โ””โ”€โ”€ report-template.md  # ๆŠฅๅ‘Šๆจกๆฟ
โ”œโ”€โ”€ references/
โ”‚   โ”œโ”€โ”€ ioc-knowledge.md    # IOC็Ÿฅ่ฏ†ๅบ“
โ”‚   โ””โ”€โ”€ db-schema.md        # ๆ•ฐๆฎๅบ“็ป“ๆž„่ฏดๆ˜Ž
โ””โ”€โ”€ tests/
    โ””โ”€โ”€ test_report.py      # ๅ•ๅ…ƒๆต‹่ฏ•

๐Ÿ”ง ๆŠ€ๆœฏ่ฆๆฑ‚

  • Python >= 3.10
  • PostgreSQL >= 12
  • ๅฟ…้œ€ไพ่ต–๏ผšpsycopg2-binary, pyyaml, pandas, jinja2

๐Ÿ“Š ้€‚็”จๅœบๆ™ฏ

ๅœบๆ™ฏ ๆŠฅๅ‘Šๅ‘จๆœŸ ้‡็‚นๅ…ณๆณจ
ๅ•†ไธš็ปผๅˆไฝ“ ๆ—ฅๆŠฅ/ๅ‘จๆŠฅ ๅฎขๆตใ€่ƒฝ่€—ใ€่ฎพๅค‡
ๅทฅไธšๅ›ญๅŒบ ๅ‘จๆŠฅ/ๆœˆๆŠฅ ่ฎพๅค‡่ฟ่กŒใ€่ƒฝ่€—ๆˆๆœฌ
ๅŒป้™ขๅญฆๆ ก ๆ—ฅๆŠฅ ๅ…ณ้”ฎ่ฎพๅค‡ใ€็Žฏๅขƒๅ‚ๆ•ฐ
ๆ•ฐๆฎไธญๅฟƒ ๅฎžๆ—ถ/ๆ—ฅๆŠฅ ๆธฉๆนฟๅบฆใ€็”ตๅŠ›ใ€็ฝ‘็ปœ
ๆ™บๆ…ง็คพๅŒบ ๅ‘จๆŠฅ ๅฎ‰้˜ฒใ€่ƒฝ่€—ใ€่ฎพๅค‡

่ฎฉ่ฟ็ปดๆŠฅๅ‘Š่‡ชๅŠจๅŒ–ใ€ๆ™บ่ƒฝๅŒ– ๐Ÿ“Š

Usage Guidance
Key things to consider before installing or running this skill: - Do NOT run the packaged code as-is. The repo contains a config.yaml with plaintext credentials for host hightop.xin (port 55432) and database 'sunway'. If you run the skill without editing the config, it will attempt to connect to that external database instead of your own. - Treat the embedded credentials as a red flag: remove or overwrite config.yaml, or replace it with a template that contains no real credentials. Prefer using environment variables (DB_HOST, DB_NAME, DB_USER, DB_PASSWORD) as suggested in SKILL.md. - Inspect scripts/generate_report.py yourself (or run in an isolated/sandboxed environment) before giving it network access. Note the script issues many SELECT queries (including personnel/access tables) which may expose sensitive data if pointed at your DB. - If you need to use this skill, create and point it at a dedicated, access-controlled database or a read-only user with minimal privileges. Verify queries and limit table access to only the columns required for reporting. - The code has small bugs/rough edges (duplicate except blocks; an except path calls a non-existent get_mock_data()), which suggests the package was not carefully audited โ€” treat it as untrusted sample code until cleaned up. If you want, I can: (1) show the exact lines in config.yaml and generate_report.py that are most concerning, (2) produce a safe config template you can drop in place, or (3) advise how to run it in an isolated container with no network access.
Capability Analysis
Type: OpenClaw Skill Name: ioc-patrol-report-cn Version: 1.0.1 The skill bundle contains hardcoded plaintext database credentials for an external host (hightop.xin) within the 'config.yaml' file, including a password and the 'postgres' administrative user. While the primary script 'scripts/generate_report.py' appears to function as a legitimate reporting tool, the inclusion of active remote credentials and the use of an external database by default is highly irregular and poses a security risk. There is no explicit evidence of data exfiltration or malicious intent against the user's local environment, but the hardcoded secrets and external connectivity justify a suspicious classification.
Capability Assessment
โš  Purpose & Capability
The skill claims to generate reports from a PostgreSQL data source and the code (scripts/generate_report.py) implements DB queries as expected. However, the repository includes a config.yaml with a hard-coded remote database (host: hightop.xin, port: 55432, db: sunway, user: postgres, password: "Q9iT6>^bZsPIX}A&"). Packaging an unrelated remote DB credential is unnecessary for the stated purpose and strongly inconsistent with expected practice (the SKILL.md suggests using environment variables or a local config).
โš  Instruction Scope
SKILL.md instructs users to edit ~/.openclaw/skills/ioc-patrol-report/config.yaml or use environment variables, but load_config() will prefer the included config.yaml if present. That means running the skill without editing will attempt to connect to the packaged external DB rather than your own. The runtime instructions do not warn about the shipped config with credentials. The code queries multiple tables (including personnel/access tables) which may contain sensitive PII โ€” callers should ensure it connects only to their intended DB.
โœ“ Install Mechanism
No install script or remote downloads are included; this is an instruction-plus-source package. There are no URL downloads or extract steps in the manifest. Dependencies are normal Python libs (psycopg2, pyyaml).
โš  Credentials
skill.yaml declares DB_HOST/DB_PORT/DB_NAME/DB_USER/DB_PASSWORD as required configuration (reasonable for a DB-backed report tool). But the repository simultaneously ships a full config.yaml with plaintext credentials for an external host. That embedded secret is disproportionate and unnecessary. Also the package metadata listed at the top said 'Required env vars: none' which contradicts skill.yaml โ€” another inconsistency.
โœ“ Persistence & Privilege
The skill does not request elevated platform privileges and has always:false. It does not modify other skills or system-wide configs. Running it will create report files under the skill's reports/ directory (expected behavior).
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install ioc-patrol-report-cn
  3. After installation, invoke the skill by name or use /ioc-patrol-report-cn
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.1
- Added detailed documentation (SKILL.md) covering core features, installation, configuration examples, report formats, use cases, advanced customization, and technical requirements. - Clarified support for automatic patrol/maintenance report generation for smart buildings and campuses, with PostgreSQL connection, and Markdown/HTML output. - Outlined common application scenarios, configuration steps, and sample use cases for commercial complexes, industrial parks, hospitals, and data centers. - Provided advanced configuration instructions for custom templates and analysis rules. - No code or feature changes; this update mainly adds user guidance and comprehensive instructions.
Metadata
Slug ioc-patrol-report-cn
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Ioc Patrol Report?

๐Ÿข IOCๆ™บ่ƒฝ่ฟ็ปดๆŠฅๅ‘Š็”Ÿๆˆๅ™จ - ไธบๆ™บ่ƒฝๅปบ็ญ‘/ๅ›ญๅŒบ่‡ชๅŠจ็”Ÿๆˆไธ“ไธšๅทกๆฃ€ๆŠฅๅ‘Šใ€‚ๅˆ†ๆž่ฎพๅค‡็Šถๆ€ใ€ๆŠฅ่ญฆ่ฎฐๅฝ•ใ€่ƒฝ่€—ๆ•ฐๆฎใ€ๅทฅๅ•่ฟ›ๅบฆ๏ผŒ็”Ÿๆˆๆ—ฅๆŠฅ/ๅ‘จๆŠฅใ€‚ๆ”ฏๆŒPostgreSQLๆ•ฐๆฎๅบ“่ฟžๆŽฅ๏ผŒ่พ“ๅ‡บMarkdown/HTMLๆ ผๅผใ€‚้€‚็”จไบŽ็‰ฉไธš็ฎก็†ใ€ๅ•†ไธš็ปผๅˆไฝ“ใ€ๅทฅไธšๅ›ญๅŒบใ€ๅŒป้™ขๅญฆๆ ก็ญ‰ๆ™บ่ƒฝๅปบ็ญ‘่ฟ็ปดๅœบๆ™ฏใ€‚ It is an AI Agent Skill for Claude Code / OpenClaw, with 116 downloads so far.

How do I install Ioc Patrol Report?

Run "/install ioc-patrol-report-cn" in the OpenClaw or Claude Code chat to install it in one step โ€” no extra setup required.

Is Ioc Patrol Report free?

Yes, Ioc Patrol Report is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Ioc Patrol Report support?

Ioc Patrol Report is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Ioc Patrol Report?

It is built and maintained by onlyloveher (@onlyloveher); the current version is v1.0.1.

๐Ÿ’ฌ Comments