BlackBerry Enterprise Server

How to remove a hidden user from a BES server

on

There are situations when a user you deleted at some point may become hidden on a BlackBerry Enterprise Server and never really was removed from the database. This is a lost user in the BES database that somehow needs to be removed or it will cause problems. You can see this lost user is taking up a license in the Blackberry Manager but you can’t actually find the user using the GUI. An example of a problem this can cause is if you try to add a user to your BES and you know you have enough licenses, but it gives you an error message saying:

“The number of users selected exceeds the number of available licenses. Please select a fewer number of users to add.”

Here is a quick way of finding the hidden user and deleting the account. Just make sure your database is backed up just incase before you begin. Then open up a command line and type in:
osql -E

Then type these commands for each line (I am going to assume you have named your SQL database the default name of BESMgmt:
1>use BESMgmt
2>select DisplayName from UserConfig
3>go

This will show you all the different users in your database. Find the user you need to remove and then type in:
1>use BESMgmt
2>delete from UserConfig where DisplayName="John Doe"
3>go

The other option that can fix remove a deleted user is by using the DBClean tool from RIM. I have hosted it here on my blog since it’s hard to find this tool sometimes.

About Jason Samuel

Jason Samuel is an Infrastructure Architect in Houston, TX with a primary focus on mobility, virtualization, and cloud technologies from Citrix, Microsoft, & VMware. He also has an extensive background in web architecture and information security. He is certified in several technologies and is 1 of 50 people globally that is a recipient of the prestigious Citrix Technology Professional (CTP) award. He is 1 of 28 people in the world that is an Atlantis Community Expert (ACE). He is a featured author on DABCC which provides the latest IT Community News on Cloud, Data Center, Desktop, Mobility, Security, Storage, & Virtualization. In his spare time Jason enjoys writing how-to articles and evangelizing the technologies he works with.

Recommended for you

Leave a Reply

Your email address will not be published. Required fields are marked *