BlackBerry® Enterprise Solution

[unhappybunny]

Just noticed that the number of active CAL on our BES is incorrect.

We have 129 CALs in total, 126 users on the BES. But the active CAL number is 128.

So I have lost 2 CAL’s somewhere. I have read a few threads that mention osql to clean up recently deleted accounts. This doesn't help.

Any ideas how I may be able to regain the licenses.

We use BES 4.1….

Cheers,

[knottyrope]

If user is stuck in pending delete, you can drop user from database using the following:

1. Open command prompt
2. Type "osql -E"
3. 1>use BESMgmt
4. 2>go
5. 1>delete from userconfig where mailboxsmtpaddr=''user@domain.com''
6. 2>go


then reboot BES after and see if it clears up

[unhappybunny]

There are no pending deletion users(not that I could see).  Unless I’m not look in the right place. Would they appear in All Users, with “Pending Deletion” as their status?

I did try that command with the last user deleted. One I remembered.  No joy.

[knottyrope]

you might have to make a list of current users and then compare to the table to find the one that is not current

[unhappybunny]

sorry i may be missing something.   Compare to what table?   i have look through the list of users showing in Blackberry Manager. the 126 that are there are correct.

[knottyrope · Accepted solution]

userconfig in SQL might show more users

maybe you need to use SSMS to look at them

Download and install MS SQL Server Management Studio Express

[unhappybunny]

Thanks i went through it via SQL userconfig table.

that worked. Thanks

[knottyrope]

so you found the ones that were not being used?

[unhappybunny]

Embarrassingly. No.   Unknown to me 2 users were not assigned Groups on our BES.  So these two appeared to be missing from the figures.

Only when comparing against the list taken from the userconfig  table in SQL was the mistake spotted.

Foolish. But I have learnt something. Thank you for all your help.

[knottyrope]

ah, that can be fun to figure out.

is your issue resolved now?