[Arkanian]

Does anyone know if the CAL count is stored in the BES database? I am trying to write an automated report for our telecom department that will check and alert when we get low on CALs.

[knottyrope]

From command-line, you can do the following:

bcp "select LicenseKey from BESMgmt.dbo.LicenseKeys where type = 0" queryout c:\licensekeys.txt -c -T -R -E -Sdbservername

That will export all installed license keys to the text file specified in the command. Just be sure to change dbservername to your SQL/MSDE server. This needs to be run from a server/machine that has bcp.exe installed, though (installed by default with SQL and MSDE installations).

[Arkanian]

Yep I can get the license keys from the table but this doesn't do me any good. I am basically looking for the total number of CALs that I have versus the number of BB users. I can get the BB user count with a simple query but I can't figure out how to get the license count unless someone knows of a way for me to figure out how many CALs a license has.

[knottyrope]

Powershell - BES Licences Used mail script - Port3101.org : Your BES Connection

but total is not automated

[TargetIT]

Exactly - the problem is that the number of CALs that each license is worth (ie 5,10, 25...) is imbedded in the license itself. RIM isn't going to provided you of a means of decrypting the license as that would also allow you to create your own. Having said that, they could create a standalone tool that does that. They haven't.