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

If you’re on a legacy ShoreTel/Mitel Connect phone system and need to find out which users have Softphone licences applied, the Director interface doesn’t offer a bulk report — you’d otherwise be checking each user account individually.

The Database Approach

ShoreTel’s Director sits on top of a backend SQL database (historically MySQL on the HQ server in older ShoreTel deployments) that stores licence assignments per user account. Connecting to it directly and querying the relevant user/licence table lets you pull this in bulk rather than clicking through Director one account at a time. Because the exact database engine, connection details, and schema differ across ShoreTel/Mitel Connect versions (and this is an unsupported, undocumented integration point rather than an official reporting API), we’d recommend:

• Confirming your current platform version’s database type and connection method with your ShoreTel/Mitel documentation or support contact before connecting directly.
• Using a read-only database account if at all possible, to avoid any risk of accidentally modifying live licensing data.
• Taking a backup/snapshot before making any direct database connection, as a precaution.

If your organisation has a Mitel/ShoreTel partner or support contract, they’ll be able to confirm the current schema and safest query approach for your specific platform version, since this has changed across ShoreTel’s various releases and its transition into the Mitel Connect product line.

Worth Knowing Before You Run This Today (Updated for 2026)

This direct-database approach still applies the same way on current Mitel MiVoice Connect deployments, but it’s worth knowing where the platform stands: add-on and security-patch sales for MiVoice Connect stopped at the end of 2024, extended licence/design support ended at the end of 2025, and full support is scheduled to run through 2029. None of that changes the licence-lookup technique itself, but it’s a reasonable point to start planning a longer-term migration if you haven’t already.

Resources

• Shoretel
• SQL
• query