Shoretel

We had an issue this week with one of our Shoretel Contact Center Agents being stuck in Release mode. When trying to Resume, the agent was getting the following error:

Your extension has lost its connection to the telephone system

We tried everything to get this working, including removing the software completely from the agents machine and reinstalling, but still nothing, so as a very last resort, we rebooted the Contact Center main server, as soon as it came back up, everything worked!

So, maybe not a solution for this issue, but it has certainly got the agent working now….we’ll be looking into why this happened next week so if we find a solution I’ll post it on here.

Finding out who has API licences 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!

ShoreTel Database Connection

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

mySQL Query

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

SELECT * FROM users WHERE AllowPAPI = 1

This will then return all the users that have an API 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.

Finding out who has a video call licence 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 drop down 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 AllowVideoCalls = 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.