A standardized collection of systems to gather metric and usage data from commercial AV control systems and related devices.
This system replaces and expands upon my previous project: Extron Database Connector
This system is for you if you've ever been asked:
- "How often is the camera actually used in this room?",
- "Can we get rid of this input device?",
- "When was the system last turned off?",
- "Has anyone ever pressed this button?"
Granular usage and metric data from your AV control systems and related devices, providing insights into how the systems are actually being used and helping inform decisions about system management, optimization and UX design.
Control processors send data to a server (or serverless cloud function) which inserts metric data into a database.
- Choose a hosting option below. Follow the readme file in the corresponding folder for detailed setup instructions.
- Incorporate the appropriate client code/driver/module into your existing control system. See the Supported Clients section below and follow the readme documents.
There are currently two hosting systems that will support any AV controller or device that can send REST requests, which should be almost all commercial AV control systems.
- Extron Control Script Python
- Generic Python 3 (simply run the ECS module on a workstation)
- Crestron C#
- AMX MUSE Python (Pure Python implementation tested working on a workstation)
- QSC Q-SYS Lua
Don't see your system here? Consider making one with the included Developer Guide
- Extron Global Configurator Plus/Pro if Extron agrees. I want to really fine tune the system before I ask them to port it to a GCP driver.
Tried one of the AI-written clients? Please provide feedback on your experience, any issues encountered, and any improvements that could be made. This will help in validating and refining these clients for broader use.
After initial setup and deployment, you will end up with a database containing usage and metric data as such: 
You can then analyze the data with scripts or visualize it in tools like PowerBI. The self-hosted PostgreSQL deployment can also publish a database port for pgAdmin or similar tools when explicitly enabled in its .env file. 
The goal of this project is to provide a solution for every major AV control system, with a variety of hosting options. I only have access to a limited number of proprietary control systems and only have experience with a limited number of cloud providers, so contributions are highly encouraged!