How to find out who has Shoretel API licences applied to their account

Finding out who has API licences applied on a legacy ShoreTel/Mitel MiVoice Connect system is another one of the licence types that Director doesn’t expose as a bulk report — same underlying limitation as Softphone and Video Call licences.

The Database Approach

The practical route is the same as for other ShoreTel licence types: connecting directly to the platform’s backend database (historically MySQL on the HQ server) and querying the relevant licence assignment table for the user list in bulk. Because this is an unsupported, undocumented integration point and the schema differs across ShoreTel/Mitel Connect versions, confirm your platform’s current database details with Mitel/ShoreTel support or your reseller before connecting directly, use a read-only account, and take a backup first — standard precaution for any direct database access against a live production phone system.

Product Naming and Platform Status

Worth flagging for anyone landing on this in 2026: ShoreTel was rebranded some years ago to Mitel MiVoice Connect (formerly “ShoreTel Connect ONSITE”), and if you’re managing an on-premises system today it’s this product you’re actually running, even if the old “ShoreTel” name is still what shows up in internal documentation or on the hardware. More importantly, MiVoice Connect is now in a formal end-of-life wind-down: add-on sales and guaranteed security patches stopped at the end of 2024, extended license and design support sales ended at the end of 2025, and full support is scheduled to end in 2029. If you’re still running this platform, it’s worth treating any database-level work like this as maintenance on a platform with a firm retirement date, and starting migration planning if that hasn’t already begun.

Alternatives Worth Checking First

Before going straight to a direct database query, it’s worth checking whether your specific Director/Connect version has since added an API licence column to any of the existing licence or user reports — Mitel has occasionally backported small reporting improvements in maintenance releases even this late in the product’s life. If a database query is still the only option, exporting the full licence assignment table to CSV once and cross-referencing it in Excel is usually faster and safer than repeated ad-hoc queries against a live production database.

Resources

• SQL
• query