BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 01-25-2010, 11:41 AM   #1 (permalink)
New Member
 
Join Date: Jan 2010
Model: 8900
PIN: N/A
Carrier: Airtel
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default How to fetch CAL information in BES 4.1

Please Login to Remove!

Hi,

I am new to this forum so forgive me if I am not asking it in a correct forum.

I have BES 4.1 and need to fetch the CAL info as we need to send the following info as daily report to management:

Total Licenses
Used Licenses
Free Licenses

What we have to do on daily basis is that we see the information in GUI and manually type the same in mails and send it.

So if any one can help me in finding if there is any SQL table or registry key where this information is stored or if there is any command to find the same.

Thanks in advance...
Offline  
Old 01-25-2010, 11:47 AM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,229
Post Thanks: 371
Thanked 379 Times in 349 Posts
Default

Click on BlackBerry Domain on the left pane.
Then in the right pane, select the 'Global' tab, expand 'Account', and choose 'License Management'.
You should see:
License Total:
Used:
Free:

Could just do a screen shot of this info and email it?

or

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).
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60

Last edited by knottyrope : 01-25-2010 at 11:49 AM.
Offline  
Old 01-25-2010, 12:11 PM   #3 (permalink)
New Member
 
Join Date: Jan 2010
Model: 8900
PIN: N/A
Carrier: Airtel
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

This does not resolve my problem:

a. Screen shot needs to be taken manually but if the value can be fetched then we can schedule it run automatically.
b. The commannd you gave just exports the license key but does not report utilization and availablity.
Offline  
Old 01-25-2010, 01:11 PM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,229
Post Thanks: 371
Thanked 379 Times in 349 Posts
Default

maybe BerryStats could help, I have not tried it.
BerryStats and Useful tools for BlackBerry Administrators
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Old 01-25-2010, 07:30 PM   #5 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

Utilization is easy to figure out (count of users in USerConfig), but total license number is difficult because the license key has the count encoded in it. You'd have to decode each key to find the quantity of each key - and I'm think RIM wouldn't like you doing that.

But then, how often do you change the number of licenses purchased?
Offline  
Old 01-25-2010, 07:48 PM   #6 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,229
Post Thanks: 371
Thanked 379 Times in 349 Posts
Default

maybe daily in OPs case.
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
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

Frieling Emsa Soft Grip Carafe Blackberry
$57.57
Frieling Emsa Soft Grip Carafe Blackberry pictureBlack & Berry Marble Cutting Machine, BB-2605, 1050W, 12000rpm
$70.78
Black & Berry Marble Cutting Machine, BB-2605, 1050W, 12000rpm picture1p PM8058 BGA IC Chip for BlackBerry Bold Touch 9900 LT15 MT15 LT18
$6.5
1p PM8058 BGA IC Chip for BlackBerry Bold Touch 9900 LT15 MT15 LT18 pictureNite Ize BHC2-03-01 Black Ballistic Nylon Blackberry Hard-Shell Case
$15.28
Nite Ize BHC2-03-01 Black Ballistic Nylon Blackberry Hard-Shell Case pictureHouse of Doolittle EcoTones Monthly Desk Pad Calendar Blackberry
$16.99
House of Doolittle EcoTones Monthly Desk Pad Calendar Blackberry picture






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