A native SwiftUI application that reads the Archiware P5 resources.db database and exports archive job data to CSV. Features a full dashboard with sidebar query browser, results table, progress reporting, and a filterable log viewer.
Ships with 13 analytical queries covering throughput analysis, storage growth trends, tape utilization, size distribution, and stale job detection. Add custom SQL queries with the {{MIN_SIZE_KB}} placeholder for configurable size thresholds.
Also includes a Volume Inventory Export powered by nsdchat โ export per-volume file inventories to a local folder and optionally copy to a network destination. Sort by LTO generation, filter archive-only volumes, export a volume list CSV, and toggle between full and read-only database access.
๐
Dashboard & Results
Sidebar query list, results table with row/column counts and execution time
๐ฟ
Volume Inventory Export
nsdchat-driven per-volume inventory with LTO generation sorting, archive-only filter, and volume list CSV
๐
Built-in Scheduler
Schedule SQL Export, Volume Export, or Both at a configurable frequency and time
๐
Live Log Viewer
Scrollable log with INFO, WARN, ERROR level filters
๐
Network Volume Sync
Auto-copy CSVs to a network share after each export
โ๏ธ
Volume Export Settings
Naming mode, overwrite control, full/read-only switch, and archive-only toggle
SQL Export
- 13 bundled analytical SQL queries
- Custom SQL directory with overrides
- Configurable size threshold (512 MB โ 50 GB)
- CSV delimiter options (comma, tab, semicolon)
- Real-time progress with query names
- Path validation with status indicators
- Read-only database access
- Shared settings with Menu Bar app
Volume Inventory Export
- nsdchat path configuration
- Local volume output folder
- Network copy destination
- Naming mode selection
- Archive-only volume toggle
- Export volume list CSV
- Full / read-only database switch
- Sort by LTO generation
- Overwrite files option
Automation
- Scheduled workflow target: SQL Export, Volume Export, or Both
- Configurable frequency
- Configurable time
Requires: macOS 12 (Monterey)+
API: SQLite (read-only) · nsdchat CLI