How to Show Shoretel User Licenses Allocations

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.