LogCollector

What problem does it solve?

This Skill eliminates the manual, time-consuming process of collecting logs from multiple servers during incidents. It automates the extraction of critical information like TrackIDs and timestamps from Excel-based task management files, connects to servers via SSH, and gathers relevant logs within specified timeframes. This significantly reduces incident response time, minimizes human error, and streamlines the entire log analysis workflow, allowing your team to focus on resolution rather than data gathering.

Core Features & Use Cases

• Excel Task Integration: Automatically processes tasks with "情報収集中" (Information Collecting) status from Japanese Excel files, extracting incident IDs, timestamps, and descriptions.
• Multi-Server Log Collection: Establishes parallel SSH connections to multiple servers (up to 3 by default) to execute efficient log searches.
• Intelligent Log Search: Dynamically extracts various TrackID formats and timestamps from task descriptions, then searches logs within a configurable time window (e.g., ±30 minutes) around the incident time.
• Dual Format Reports: Generates comprehensive reports in both Excel (with summary sheets, detailed log entries, and formatting) and CSV (plain text for easy import) for flexible analysis and sharing.
• Use Case: During a critical system outage, quickly gather all relevant logs for multiple incident IDs across your web, application, and database servers. The Skill compiles these into a single, searchable report, enabling your incident response team to diagnose issues faster and more accurately.

Quick Start

Collect logs for all '情報収集中' (Information Collecting) tasks from the attached Excel file 'incident_tasks.xlsx' and generate a detailed report.