BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-19-2005, 12:11 PM   #1 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7100
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb Building a Report, a BESMgmt question

Please Login to Remove!

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
Offline  
Old 10-19-2005, 02:58 PM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 10-19-2005, 04:13 PM   #3 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7100
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thats what I was thinking. Spend a hour looking through all the SQL tables.
Offline  
Old 10-19-2005, 06:55 PM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: May 2005
Model: 7100
Carrier: T-Mobile
Posts: 299
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.