How to find out who has Shoretel Video Calls licences applied to their account

Similar to identifying Softphone licence assignments, finding out who has Video Call licences on a legacy ShoreTel/Mitel MiVoice Connect system isn’t exposed as a bulk report in Director — it’s a per-account checkbox/dropdown you’d otherwise have to check one user at a time.

The Database Approach

As with other ShoreTel licence lookups, the practical route for bulk reporting is connecting directly to the platform’s backend database (historically MySQL on the HQ server for older ShoreTel deployments) and querying the relevant licence assignment table. Because this is an unsupported, undocumented integration point and the exact schema varies by ShoreTel/Mitel Connect version, we’d recommend confirming your platform’s current database details with Mitel/ShoreTel support or your reseller/partner before connecting, using a read-only account, and taking a backup first as a precaution — the same caution that applies to any direct database access against a live phone system.

Product Status Worth Knowing

Anyone landing on this in 2026: ShoreTel is now Mitel MiVoice Connect, and the platform is in an active end-of-life wind-down — add-on and guaranteed security-patch sales stopped at the end of 2024, extended licence and design support sales ended at the end of 2025, and full support is scheduled to end in 2029. If you’re still doing licence audits like this on the platform, it’s worth treating the work as maintenance on a system with a firm retirement date rather than a long-term reporting solution to build further tooling around.

A Quicker Check for a Handful of Users

If you only need to check a small number of accounts rather than a full bulk export, going through Director’s per-user licence tab is still faster than setting up database access for a one-off lookup — the database route earns its keep once you’re checking dozens of accounts at a time or need this as a repeatable, scheduled report.

Resources

• SQL
• query