Version History

v1.5

Data Tables

• Resizable columns — Drag the right edge of any column header to widen or narrow it; useful for long client names, target paths, and message text
• Full data in CSV exports — Long values that were clipped to 30 / 60 / 150 / 200 characters in the table view are now exported in their entirety, so FileMaker imports of FMS Detective CSVs line up
• Row selection and copy as TSV — Click any row to select; Shift-click or Cmd-click to extend; the Copy button (or right-click → Copy as TSV) puts the rows on the clipboard ready to paste into Excel, Numbers, Sheets, or FileMaker
• Right-click context menus on table rows

Chart Export

• Save as PNG or PDF — Right-click any chart to export; filenames are descriptive (Top Call Stats Elapsed Time Trends) instead of generic "Chart"
• Drag charts out — Click and drag any chart to the Desktop, into a Slack draft, or into another app; same descriptive filename as the Save menu

AI Assistant

• DDR enrichment now reaches AI prompts — When a DDR is loaded, the AI Assistant sees MyDatabase::Customers [12,450 records, 3 unstored calcs] instead of MyDatabase::table(25); analysis can now reference your actual tables, and field-level annotations (data type, indexing, unstored calc) feed real diagnostic signal into the model

Text Selection

• Selectable text throughout the app — Highlight and copy from AI analysis output, table cells, log entries, in-app help, and settings panels

Performance & Polish

• Null bytes in log files no longer derail parsing — some FMS environments produce log files with stray null bytes that previously caused the parser to bail out
• Troubleshooter spike card clicks were being intercepted by the new text selection — clicks now correctly drill into the spike
• Chart drag-out filename used PNG Image.png instead of the descriptive Save-menu filename

v1.4

Range Filter

• Drag-to-filter on timeline charts — Drag across any timeline chart (Event Log, Access Log, Data API, OData, Script Events, Top Call Stats, Client Stats, Server Stats, Admin Console, WPE) to filter the data table to a selected time range
• Per-view, with a global date filter underneath — A "Clear" button above the chart resets the range; replaces the previous single-click bucket filter on timeline views
• Server Stats coordinated drag — Dragging on any of the three charts (Clients, Performance, Disk I/O) highlights all three together

AI Assistant

• Customizable prompts — Settings → AI Prompts overrides the default analysis question for any of 16 supported views; customizations persist across launches
• Updated model guidance — 7B+ models recommended; smaller models often hallucinate details that aren't actually in the log

Diagnostic Mode (Parser Unknowns)

• Opt-in developer feature — Settings → Diagnostics → "Capture parser unknowns" surfaces log lines the parsers couldn't fully interpret, grouped by parser
• Anonymized samples — Quoted strings and IP addresses redacted, with one-click Copy All and Email to Developer actions
• Default OFF — Useful for reporting parser gaps

Server Stats

• New stat cards — Max Open Databases (peak) and Min Cache Hit % (worst dip)

Client Stats

• Max Elapsed stat card — Worst single client-interval

Admin Console (FAC log)

• Lifecycle line parsing — Starting / Stopping / Killing FAC node and facstart.sh execute lines now parse and appear in the data table instead of being silently dropped

Performance & Polish

• Numeric sort on duration and byte columns in Client Stats and WPE (previously string-prefix order)
• Settings persistence — thresholds, custom prompts, and toggles now survive relaunch
• In-app help updated for all v1.4 features, with chart-interaction copy corrected to match the new range filter behavior

v1.3

DDR Import

Import a FileMaker Database Design Report (DDR XML) and FMS Detective enriches your log analysis with real table and field names, replacing the raw internal IDs that FileMaker writes to logs.

• Top Call Stats — Targets like tableID=128, fieldID=42 now display as Customers::EmailAddress with inline annotations for field type, indexing, and validation
• Troubleshooter — Same name resolution applied to flagged operations
• Health columns — Table-level annotations (records, unstored calcs, unindexed fields) shown directly on top targets
• Help entry — New "DDR Import" topic explains how to export a DDR from FileMaker Pro and what the snapshot-staleness limitation means

How to use it: in FileMaker Pro → Tools → Database Design Report → export as XML → drag into FMS Detective.

Admin Console

• Added Errors/Warnings timeline chart and a filter bar with active-filter chips
• Clickable Top Repeated Messages table groups messages by normalized template (digits collapsed to #) so the noisiest patterns surface instantly

WPE Log

• New request timeline chart with click-to-filter
• Clickable error code table, "Errors Only" table toggle, time-bucket filter chips, unified Errors stat card

Event Log

• Added timeline chart matching Data API / OData style
• Replaced segmented severity picker with multi-select toggle chips so you can view any combo (e.g. Warning + Error without Information)

Server Activity Timeline

• Graduated out of Beta; Beta tag removed from sidebar

Performance & Polish

• Fixed main-thread hang when sorting string columns with DDR-resolved accessors in any data table
• Fixed Event Log timeline beachball on large (25k+ entry) datasets
• DDR XML parser now sanitizes FileMaker styled-text control characters that previously broke parsing
• Help view icons now match sidebar icons

v1.2

Troubleshooter

• Chart accuracy fixes — Remote Calls In Progress, Elapsed per Call, and Cache Hit % charts now use max-per-bucket downsampling that preserves every spike, replacing stride-sampling that could hide entire days of concurrency activity on long-range logs
• Log-scale Y-axis on Elapsed per Call — Logarithmic axis from 0.1 ms to the actual worst spike with human-readable tick labels (e.g. "10 ms", "1.0 s"), so brief spikes and sustained slowdowns are visually distinct
• Clickable charts and jump-to-spike stat cards — All three Step 1 charts are now clickable to jump to spike details, and summary stat cards above the charts act as quick-jump buttons to the worst spikes

Server Activity Timeline

• Client connection sessions — The timeline now shows when clients connected and disconnected as session bars alongside existing event layers
• Per-database open/close tracking — Each database's lifecycle is tracked and rendered on the timeline with expandable session details
• Smarter defaults — Timeline defaults to Schedule, PSoS, Pro, and Data API event layers

Data API & OData

• Request timeline charts — Interactive timelines with click-to-filter
• Human-readable error codes — FMS CLI error codes resolved to descriptions
• Clickable error table — Replaces the error code bar chart

Log Correlation

• OData / Data API split — Tracked as separate log types for more accurate cross-log correlation
• By Log timeline — New view showing activity across all loaded log files on a single timeline

Script Events

• Timeline chart — Shows script execution activity over time
• Multi-file date ordering fix — Entries now sort correctly across rolled Event.log files

Performance & Polish

• Chart color stability — multi-series charts now use deterministic, consistent colors
• Rolled log file detection — files like fmodata.log.1 and Stats.log.1 are now recognized
• Open in Browser — new button to open FileMaker Server Admin Console when connected to a live server
• Fixed hang when viewing full-range Server Activity Timeline with all event layers enabled
• Updated help content for Data API, OData, and Script Events views

v1.1

Server Activity Timeline (Beta)

• 24-hour Gantt chart — Visualize Schedule and Perform Script on Server sessions with concurrency tracking, color-coded status bars, day navigation, and click-to-inspect session details

AI Assistant

• LM Studio support — Second local LLM provider alongside Ollama with a unified model picker showing all available models tagged by source
• Day-scoped analysis — AI analysis scoped to the selected day in the Server Activity Timeline
• Problem-first prompts — AI prompts prioritize timeouts, aborts, and errors over generic summaries
• Token budget improvements — Live dataset size warnings before sending to the model

Log Correlation

• Streamlined 2-step flow — Richer root cause analysis, configurable detection thresholds, and noise error filtering

Top Call Stats

• Activity Heatmap — Date × hour grid; click cells to filter
• Clickable Elapsed Time Trends — Click trend points to filter by time range
• Top Operations metric switcher — Toggle between Calls, Elapsed, Wait, and I/O

Access Log

• Database Activity Summary — New panel showing per-database activity with expandable rows, connected users, file sizes, and encryption indicators

Server View

• Expanded server context — Services grid, SSL certificate details, database and schedule definitions

Performance & Polish

• Click-to-filter on Client Stats, Script Events, and Data API charts
• Clickable StatCards with subtle color tint on interactive summary cards
• Background recompute for heavy calculations
• Min/max downsampling preserves spikes instead of averaging them away
• Search box debounce with cancellation for smoother filtering
• Expanded help system with dedicated pages per log type

v1.0

Initial release.

• Parse and analyze 12 FileMaker Server log types with automatic format detection
• Performance Troubleshooter — guided 3-step diagnosis from spikes to clients to operations
• Log Correlation (Beta) — cross-log anomaly detection with root cause analysis
• AI Assistant — local LLM integration via Ollama for on-device analysis
• FileMaker Admin API integration for live server context
• Drag-and-drop import with multi-file support up to 200 MB per file
• CSV export of analyzed data
• 100% local processing — no data leaves your machine