How to Resolve Problem Deleting User from Blackberry Professional or Enterprise Manager

After deleting a user from Blackberry Professional or Enterprise Manager, on some occasions the user count will not update. This is because the user has been deleted from the Manager display but not from the database. This will prevent you from adding the same user back into the Manager interface.

To resolve, you will need to Manually Purge the user from the Blackberry Manager Database.

From the server that is hosting the database:
open a Command prompt
type the following (the -E is case sensative):
osql -E SERVERNAME\DATABASENAME (substitute the database server name for SERVERNAME and the blackberry database name for DATABASENAME)
hit enter
at 1> enter: use BESMgmt
press enter
at 2> enter: select DisplayName from UserConfig
press enter
at 3> enter: go
press enter

this will display a list of Displaynames for all users in the Blackberry Database. Locate the displayname for the user you need to purge. Then purge that user by performing the following:
at 1> enter: use BESMgmt
press enter
delete from UserConfig where DisplayName="DISPLAYNAME of user to Purge"
press enter
at 3> enter: go
press enter

if you have entered the command correctly, it should respond with a message confirming at a row was deleted.

at 1> enter: exit

In the Blackberry Management itnerface, the user count should now reflect the deletion of the user.