How to find out who has Shoretel Softphone licences applied to their account

Shoretel Orange and Black Logo

Last updated on April 16th, 2023 at 11:24 pm

Read Time:58 Second

Finding out who has softphones in your Shoretel system can be tricky as there is no way of doing it in the Director apart from going through every single user account and checking the tick box.

If you are like me and have 1000’s of users – this really isn’t possible. But, there is a solution!

If you logon to your main HQ server (where your MySQL Database is) and run the MySQL software you will be asked to connect to a database. The settings you need to enter are as below:

MySQL Host Address: localhost
Username: (whatever username it is – default is root)
Password: (whatever username it is – default is shorewaredba)
Port: 4308
Database: shoreware

Connect to the database and you can then enter an SQL query. The query you need to run is:

SELECT * FROM users WHERE AllowSoftPhone = 1

This will then return all the users that have a softphone licence allocated to them – this can then be viewed or exported to CSV.

Comments

If you have any comments or questions about this, please feel free to leave them below and we will get back to you as soon as we can.

Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 441 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.