How to Show Shoretel User Licenses Allocations

Checking ShoreTel User License Allocations via SQL

If you’re running a ShoreTel (now Mitel) telephony system and need to see which extensions are consuming which type of license — Extension Only, Standard User, Premium User, and so on — the quickest way to get a full picture is a direct query against the ShoreTel SQL database rather than clicking through each user one at a time in Director. Log in to your Headquarters server, open SQL Server Management Studio, and connect to the main ShoreTel database. From there, a simple query against the USERS table filtered on the license type column will list everyone on a given license:

SELECT * FROM USERS WHERE LICENSETYPE = 'ExtOnly'

Swap the value being matched to whichever license type you’re auditing. Running it without a WHERE clause (or grouping by LICENSETYPE) will give you a full breakdown across every license type in one go, which is useful when checking usage against your purchased license counts before a renewal or an audit. Note: only ever run ad-hoc SELECT queries like this against the production ShoreTel database — never UPDATE or DELETE directly against ShoreTel’s tables, since the system’s own services expect to manage that data exclusively through Director and the ShoreTel/Mitel APIs. Direct writes can corrupt the telephony system’s configuration.

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

If you’re still administering a ShoreTel-branded system, it’s worth knowing where the platform actually stands: ShoreTel is now Mitel MiVoice Connect, and the product is in active end-of-life wind-down — add-on and security-patch sales 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. The direct-SQL license-check technique in this guide is unaffected by that timeline and remains the quickest way to audit allocations across a large user base, but it’s worth factoring the platform’s EOL trajectory into any renewal or licence-count planning you do off the back of this query.

Resources

• query