BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-19-2005, 11:11 AM   #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, 01: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, 03: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, 05: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

Aldelo Restaurant Bar Pizza 3 POS Systems/Stations PRO Version NEW I3 PROCESSOR
$3399.99
Aldelo Restaurant Bar Pizza 3 POS Systems/Stations PRO Version NEW I3 PROCESSOR pictureSmith Corona Typewriter Model XD4900 IQ Electric Word Processor w/Ribbon Working
$95.99
Smith Corona Typewriter Model XD4900 IQ Electric Word Processor w/Ribbon Working pictureKleco Tissue Pulverizer Model 2000 Laboratory Cryogenic Grinding Processor
$99.99
Kleco Tissue Pulverizer Model 2000 Laboratory Cryogenic Grinding Processor pictureAllen Bradley SLC 500 Processor Unit 1747-L524 Ser C Frn 7C
$55.0
Allen Bradley SLC 500 Processor Unit 1747-L524 Ser C Frn 7C  pictureSiemens 6ES7214-1BD23-0XB0 6ES7 214-1BD23-0XB0 SIMATIC S7-200 CPU 224 Controller
$395.0
Siemens 6ES7214-1BD23-0XB0 6ES7 214-1BD23-0XB0 SIMATIC S7-200 CPU 224 Controller picture






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