skills.rest
shiftrepo
shiftrepoOFFICIAL
Explore all skills by this author →
GitHub

LogCollector

Collects incident logs via SSH from Excel task lists and generates reports.

Updated Aug 25, 2025
Search Tags:#automation#logs#reporting#excel#ssh#incident management#multi-server
One-click install
npx skills add https://github.com/shiftrepo/ai_workshop --skill logcollector
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: LogCollector
Source: https://github.com/shiftrepo/ai_workshop/tree/main/log-collector-tool/log-collector-skill
Command: npx skills add https://github.com/shiftrepo/ai_workshop --skill logcollector

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires chalk, exceljs, ssh2, and includes scripts (resource) and references (resource) and assets (resource) components.

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.

Frequently Asked Questions about LogCollector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate log collection from multiple servers during incident response?▼

Automate log collection by extracting incident IDs and timestamps from Excel task files, then use SSH to query multiple servers in parallel and gather logs within a specified time window. This eliminates manual log searches across servers and generates searchable reports automatically.

Can I collect logs from multiple servers using SSH and Excel data?▼

Yes. This Skill reads Excel files with Japanese status markers, extracts TrackIDs and timestamps, establishes parallel SSH connections to up to three servers, and retrieves logs matching those identifiers within a configurable time range around the incident timestamp.

What formats can I export incident logs to after collection?▼

Collected logs are generated in both Excel and CSV formats. Excel reports include summary sheets and detailed log entries with formatting; CSV provides plain text output for easy import into other analysis tools or systems.

Do I need read-only SSH access to use this log collection automation?▼

Yes. This Skill requires read-only SSH access to target servers to execute log searches. It extracts multiple TrackID patterns dynamically and queries logs without modifying server data.

How does this handle Excel-driven incident workflows with Japanese task status markers?▼

The Skill automatically processes tasks marked with '情報収集中' (Information Collecting) status from Excel files, extracting incident details and descriptions to identify what logs to search for and when they occurred relative to the incident.

What's the fastest way to gather logs for multiple incidents across different servers?▼

Use parallel SSH connections to query up to three servers simultaneously based on incident data in Excel. This Skill handles TrackID extraction, time-window calculation, and concurrent queries to minimize incident response time.

Related Skills

Explore More Software Engineering Skills→
takusaotometakusaotome
5

multi-file-log-correlator

Merge heterogeneous log files into a unified timeline with correlation and gap detection.

Community
Intermediate
PromakerDevPromakerDev

report-app-down

Diagnoses a specified application and outputs a structured report.

Official
Intermediate
DoubleslashSEDoubleslashSE
4

log-analysis

Parse infrastructure logs to extract actionable insights for incident detection.

Community
Intermediate
opencodosopencodos
14

errors

Aggregate and analyze Claude Code errors from JSONL logs and system logs.

Official
Intermediate