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

Shoretel Orange and Black Logo

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.

How to find out who has Shoretel Video Calls licences applied to their account

Shoretel Orange and Black Logo

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.

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

Shoretel Orange and Black Logo

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 … Read more

Customise Shoretel ringtone on all models of handsets

Shoretel Orange and Black Logo

If you want to customise the ringtone of all the (for example..) IP230 handsets in your business, below is a tutorial video on how to do this quickly and simply.

If you need any assistance with how to do this or if you have any problem, leave a comment and I’ll help you out as soon as I can.

How to create a bootable USB SCCM imaging stick

sccm logo

First you need to plug in a USB memory stick to the SCCM server.

Please also be aware that the Windows XP image requires at least a 8GB memory stick and the Windows 7 image requires at least a 16GB memory stick.

Once the stick is showing on the server as a usable device, go into the SCCM console on the server. You then need to browse to the following as per below:

Computer Management > Operating System > Task Sequences

Then highlight the image task sequence that you wish to use to create the memory stick. Right click on this image and select “Create Task Media”

This will take you to the “Task Sequence Media Wizard”, on this page select “Stand-Alone Media and click next.

On the Media Type page select “USB Flash Drive” and click next.

You will see a warning telling you that this will format the media, click Yes to continue.

On the Security page you will be asked to enter a password – always do this. Enter a password and click next.

You will then be asked which task sequence you wish to run, select the “Operating System Image” and click next

On the Distribution Points page, you need to add each of the DP’s to the media, so highlight each one and click “Add”, then click next.

Then follow all the defaults through the rest of the wizard and SCCM will then create the USB memory stick with the correct task sequence and image.

Please note that this can take some time to create dependant on the speed of the server and the size of the original image.

Adobe updates via Windows Updates (WSUS/ConfigMgr/SCUP)

Adobe Reader DC version 2001

You can update Flash Player and Adobe Reader via Windows Updates using SCUP through WSUS/SCCM. Download SCUP: Download System Center Update Publisher Here Then once installed and configured on your server, you can connect to the Adobe catalogs for Reader and Flash Player and publish them to WSUS/SCCM to be pushed out via windows updates. … Read more

Adobe Flash Player – Push out via SCCM

Adobe Reader DC version 2001

If you are looking at pushing out or just updating Adobe Flash Player via SCCM – follow this procedure. First download the latest version of flash player – usually filehippo.com is your best bet for this, but Google it and you’ll find the full download easily enough rather than the online install at adobe.com. You … Read more

WinRAR Uninstall using SCCM or silent command line

WinRAR-Logo

This is another fairly simple one – again no need to create a package, just a Program command line, this assumes that your clients have installed WinRAR to the standard default location – this can be changed if required… Then just push this out to a collection. My personal preference is to create a collection … Read more

Google Earth SCCM Uninstall

google earth pro MSI logo

The best way to ensure Google Earth gets removes is to collect the Google Earth.msi file that is put into the %temp% directory when installed – but you have to make sure that you use the correct version for the version installed.

So, create a report in SCCM for all Google Earth installs with file version (let me know if you need a report query for this)- then download the various versions (if there are different ones), install on your own machine or a temp or lab machine, go into the %temp% directory and copy out the Google Earth.msi file.

Then, create a package with this file in it only, then use the following as your Program command line:

msiexec.exe /x google earth.msi /qn

Advertise it where you want to remove it (remember to use the correct version though) and it will work.