code.matx.ca

P5 Archive Tools for macOS

Native applications for Archiware P5 data management and verification

🗄️

P5 Archive Manager

File verification & archive status

nsdchat CLI
Drag-and-drop interface to verify if files have been archived. Get detailed reports with barcodes, volume IDs, and archive dates.
Learn more →
📊

P5 Archive Overview

Archive jobs & pool monitoring

REST API
Query current and historical archive jobs via REST API. Monitor pool usage and track archive operations over time.
Learn more →
🔍

P5 Archive Search

Index inventory browser & search

REST API
Browse and search P5 archive index inventory. Navigate directories, build a local database, and find archived files quickly.
Learn more →
📤

P5 Archive Export

CSV export & job analytics

SQLite
Export archive job data to CSV with 13 built-in queries. Available as a windowed app and a menu bar utility with shared settings.
Learn more →
New

P5 Archive Export

Native macOS apps for exporting Archiware P5 archive job data to CSV. 13 built-in analytical queries, configurable scheduling, and network volume sync — available as a full windowed app or a lightweight menu bar utility.

13

Built-in Queries

Throughput analysis, storage growth, tape utilization, and more

⏱

Automated Scheduling

Daily, weekly, or monthly exports with configurable time

🔒

Read-Only Access

Opens resources.db in read-only mode — never modifies P5 data

🔌

Custom SQL Support

Add your own .sql files with {{MIN_SIZE_KB}} placeholder

🖥

P5 Archive Export

macOS 12+ · SwiftUI · v1.1
Full windowed app with dashboard, sidebar query browser, results table, real-time progress, and log viewer with level filtering.
Learn more →
📦

P5 Archive Export MenuBar

macOS 14+ · SwiftUI · v1.1
Lightweight menu bar utility — no Dock icon. One-click exports, inline settings, and quick status checks from the popover.
Learn more →
🗄️

P5 Archive Manager

Uses nsdchat CLI

A native macOS application designed to verify which files have been archived by Archiware P5. Simple drag-and-drop interface to check folders against your P5 Archive with detailed reporting.

The app leverages the Archiware nsdchat command-line interface to query archive status, making it ideal for environments where direct CLI access to the P5 server is available.

✓

Quick Verification

Drag-and-drop to check if files are backed up

📊

Detailed Reports

File size, archive date, barcodes, volume ID

🖥️

Multiple Servers

Configure multiple P5 server connections

📝

Comprehensive Logging

Complete execution logs with timestamps

View on GitHub Download Release

Key Features

  • Custom archive index support
  • Local and remote P5 servers
  • Real-time log monitoring
  • CSV export functionality
  • Secure keychain credential storage
Latest: v2.8
Requires: macOS 14.6+
API: nsdchat CLI
📊

P5 Archive Overview

Uses REST API

A native macOS application designed to query current and recent archives via the P5 REST API. Monitor archive job status, view pool usage, and maintain historical records of archive operations.

Uses the Archiware P5 REST API endpoint /rest/v1/archive/overview to retrieve archive job data, making it accessible from any machine on the network without requiring CLI installation.

📈

Job Monitoring

View current and completed archive jobs

💾

Pool Usage

Monitor storage pool capacity and usage

🕐

Historical Data

SQLite database for historical tracking

📤

Export Options

JSON and CSV export functionality

View on GitHub Download Release

Key Features

  • Multiple server support
  • Current and historical job views
  • Pool usage monitoring
  • SQLite history database
  • CSV and JSON exports
Latest: v1.6
Requires: macOS 14.0+
API: REST /archive/overview
🖥

P5 Archive Export

SQLite · macOS 12+

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.

📊

Dashboard & Results

Sidebar query list, results table with row/column counts and execution time

📅

Built-in Scheduler

Daily, weekly, or monthly exports at a configurable 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

View on GitHub Download Release

Key Features

  • 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
Latest: v1.1
Requires: macOS 12 (Monterey)+
API: SQLite (read-only)
📦

P5 Archive Export MenuBar

SQLite · macOS 14+

A lightweight menu bar companion that provides the same export engine as the windowed app, accessible from an always-visible archive box icon. No Dock presence — click the icon to open a popover with status, one-click exports, and inline settings.

Shares the same P5ExportCore library and settings as the full Mac app. Add it to Login Items for unattended, always-on scheduling on your P5 server.

📌

Always Available

Lives in the menu bar with no Dock icon

⚡

One-Click Export

Instant export with progress indicator in the popover

🔄

Shared Settings

Synced with the windowed app via common settings

🚀

Login Item Ready

Start at login for unattended server scheduling

View on GitHub Download Release

Key Features

  • Menu bar popover with status display
  • Last run info with CSV and row counts
  • Next scheduled run indicator
  • Compact inline settings panel
  • Same 13 built-in queries as Mac app
  • Custom SQL directory support
  • Network volume auto-copy
  • Login Items integration
Latest: v1.1
Requires: macOS 14 (Sonoma)+
API: SQLite (read-only)

P5 Archive Bash Scripts

Collection of bash scripts for P5 Archive automation and management

View Scripts on GitHub

api-archive-overview

Get the overview of recent archive jobs via the API.

api-archive-pool-usage

Check archive pool usage via the API.

jobs-sql2csv

Show all historical system, backup and archive jobs on a P5 server.

jobs-archive-only-sql2csv

Output an Archive only CSV with: Job #, Date, Size, Name.

vol2tsv-all

TSV inventory for all archive volumes without barcode in the filename.

volt2tsv-archive-barcode

TSV inventory for archive volumes with P5 volume and LTO barcode in filename.

volume-archive-full2readonly

Find archive tapes marked "Full" and change mode to "Readonly".

volume-full-vs-appendable

Find tapes by status: Full/Readonly vs Appendable with used size in TiB.

volume-list

Create a P5 volume list as CSV and save to /private/tmp/.

p5-check

CLI predecessor to P5 Archive Manager - verify folder archive status.

Example Usage

All scripts are tested on macOS in the Bash shell. Output is usually set to /private/tmp. With some slight modification these scripts should run in BSD / Linux systems with bash. They expect the Archiware CLI (nsdchat) to be installed where noted.

# Example: write all archive jobs to CSV in /private/tmp/
./jobs-archive-only-sql2csv.sh 

# Example: create per-volume TSV inventory of full archive tapes with barcode
./vol2tsv-archive-barcode.sh /private/tmp/tsv_output

# Example: find full archive tapes and mark them as read only
./volume-archive-full2readonly.sh