Fixture Database

Fixture Database

The Fixture Database tracks operating hours and usage data for every individual RDM fixture by its UID. This data persists between sessions, building a maintenance history over time.

What It Tracks

For each fixture (identified by UID):

• Device hours — total powered-on time
• Lamp hours — lamp or LED source operating time
• Lamp strikes — number of lamp ignitions
• Power cycles — number of power on/off cycles
• Manufacturer and model — for identification
• Last seen timestamp — when the fixture was last discovered

Each reading is timestamped, building a usage history over time.

Recording

The database records automatically during RDM discovery. A Recording toggle lets you pause and resume database writes without stopping RDM — existing data is preserved.

A configurable minimum interval between snapshots prevents redundant recordings when the same fixtures are seen repeatedly in a short time.

Viewing Data

Open the Fixture DB tab in the RDM inspector to see all recorded fixtures. The table shows the latest readings for each fixture, sorted by UID.

CSV Export

Click Export CSV to save the entire database as a CSV file. This is useful for:

• Integration with external asset management systems
• Maintenance scheduling in spreadsheet tools
• Fleet reporting across multiple venues

External Database

The fixture database is stored as a separate file that can be backed up, shared between machines, or loaded on a fresh installation to maintain continuity.

Cleanup

Use the Clear button to remove all recorded data — useful when moving to a new venue or starting a fresh maintenance cycle.

Use Case: Rental Company

For rental companies, the fixture database answers questions like:

• How many hours does unit 09ae:06500060 have?
• Which fixtures in the fleet are approaching the lamp replacement threshold?
• When was each fixture last seen on a network?

Combined with RDM Templates (lamp hours limit warnings), this provides a complete maintenance workflow.