[tcolgrove]

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

[jibi]

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.

[tcolgrove]

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

[BBTechGuy]

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.