BlackBerry Enterprise Server

How to remove a hidden user from a BES server

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

Advertisement. Scroll to continue reading.

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.

Advertisement. Scroll to continue reading.

Leave a Reply

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

You May Also Like

Apache

Today I would like to go over proper URL redirection when using SSL but first I would like to preface this by describing what...

Exchange 2003

A useful Exchange 2003 guide I wrote for a friend’s blog originally but I am posting it here on mine now for your viewing...

Citrix Workspace

You can use FIDO2 hardware security keys plugged into your physical desktop over the Citrix HDX remoting protocol for use with virtualized Windows Desktop...

Cloud Design Architecture

The community-driven paperback book initiated by my friends Bas van Kaam and Christiaan Brinkhoff is available for sale on Amazon. If you haven’t picked...

JasonSamuel.com was launched in 2008 as a platform to give back to the IT community by sharing knowledge and expertise. Over the years, it has become a trusted global resource for the latest insights, how-to guides, and forward-thinking leadership on enterprise mobility, security, virtualization, cloud architecture, automation, and other cutting-edge technologies. Today, it serves as a go-to reference hub for IT professionals, attracting hundreds of thousands of unique visitors from around the world each month. Learn more on the About Me page.
Copyright © 2008-2025 JasonSamuel.com

Exit mobile version