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.
If you have any questions on this guide, please feel free to leave us a message below using our Disqus system.