How to Show Shoretel User Licenses Allocations

Last updated on April 17th, 2023 at 12:17 am

If you have a Shoretel telephony system in your corporate environment and you want to know which extensions have which licenses, then you can do this by running a simple query across your Shoretel MySQL database.

Login to your HQ server and open MySQL and login to your main Shoretel database. Then run these following queries on it:

Show all users who have Extension Only licenses:

SELECT * FROM USERS WHERE LICENSETYPEID = 2

Show all users who have Extension and Mailbox licenses:

SELECT * FROM USERS WHERE LICENSETYPEID = 1

This should then return the information you are looking for.

Comments

If you have any questions on this guide, please feel free to leave us a message below using our comments section.