Usage

Add Log In the Table

Reads the specified number of events and inserts them into the database.

LogReader

LogReader is a lightweight Windows Event Log extraction tool designed to collect, filter, normalize, and store Application Log events into a MySQL database.
It provides a minimal web interface for triggering log collection, clearing the database, and inspecting stored entries.

---

Overview

Windows Event Viewer is powerful but slow and inconvenient for quick analysis.
LogReader offers a fast, script‑driven alternative that:

• Reads events directly from PowerShell
• Filters only relevant Event IDs
• Normalizes timestamps and messages
• Stores everything in a structured MySQL table
• Provides a simple HTML interface for interaction

This makes it ideal for debugging, monitoring, or forensic‑style inspection on local systems.

---

Features

• PowerShell-based log extraction using Get-EventLog or Get-WinEvent
• Customizable Event ID filtering
• Automatic message sanitization (removes paths, noise, blank lines)
• MySQL storage with normalized fields
• One-click database wipe (TRUNCATE)
• Minimal UI for:
  • Starting log extraction
  • Clearing all logs
  • Setting the number of events to read
  • Viewing stored logs

---

Remove all Log In the Table

Clears the entire log table using TRUNCATE.

Number of logs to read

Defines how many events to extract from Windows logs.

See all log

Outputs all stored log entries (raw format).

---

Technical Notes

• Get-WinEvent may fail with large event counts; Get-EventLog is more stable.
• Some event categories may require elevated privileges.
• JSON output from PowerShell may need increased depth for complex messages.
• The project is intentionally minimal and easy to extend (filters, categories, export, etc.).