Running BES 4.0 SP2. I am writing a custom report via a SQL query to get user infor, stats, etc.
For the life of me, I cannt find in the db anywhere where it says the number of licences we have. I can find the licence keys, but not a number (ie 150 licences)
I want to use this to also show our licence status, so we can make sure we order more licences well in advance.
Any help would be awesome.
Thanks,
TC

I believe this part is built in to the software not the database. Most likely the software has a way of determining how many licenses are available for said license key.

Thats what I was thinking. Spend a hour looking through all the SQL tables.

If you want to see what database calls are being made when you check the License total in the BlackBerry Manager you can use SQL Profiler.