BPS licensing problem

[dallen37]

I am new the BB Admin role....
I have Black Berry Professional Server installed for exchange.
The server states how many devices are licensed but it is off by one.
Meaning I have 20 connected Blackberry's and the server shows 21 licenses in use. Any ideas?

Thanks,
D

[GlenB]

In full blown BES you have the option to purge the users from the database. This option isnt present in BPS and I have seen situations where the record for the deleted BES user hasnt been removed from the underlying Users table. The example below shows the general method of doing this using the osql command line. Exercise caution - this is your BES database after all - and use at your own risk. Having said that, the first sequence will just list the users in the table, giving you an indication of whether this is where your problem lies. The second and third sequence are alternative ways of deleting a user record when it stubbornly persists - you would only use one of these methods, not both. If you feel uncomfortable with any of these commands, dont use them.

Display users in userconfig table
C:\osql -E -S <SERVERNAME>\<INSTANCENAME> (i.e. NICAEA\SQLEXPRESS)
1> use databasename (i.e. BESMgmt)
2> select id, DisplayName from UserConfig
3> go

Delete user whose id number is 00 - Use this carefully and at your own risk
Id,Name Here
(x row affected)
1>delete from UserConfig where Id=00
2>go

Delete user whose DisplayName is "name" - Use this carefully and at your own risk
Id,Name Here
(x row affected)
1> delete from UserConfig where DisplayName="name"
2> go