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 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.

Resources

• SQL
• query