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.

About The Author

Andrew Armstrong

Andrew Armstrong is a UK-based IT professional with 26+ years of hands-on experience in Windows, Windows Server, SCCM/ConfigMgr, Active Directory, PowerShell, and enterprise infrastructure. He founded TechyGeeksHome in 2010 and has published over 1,500 practical guides covering real-world IT problems and solutions. When not solving IT problems, Andrew develops free Windows utilities including Ultimate Settings Panel, which has been downloaded over 850,000 times.

See author's posts