BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-20-2008, 05:05 PM   #1 (permalink)
New Member
 
Join Date: Jun 2008
Model: 8310
PIN: N/A
Carrier: Tmo
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default List BB by model

Please Login to Remove!

I'm trying to get a list of all blackberries on a BES separated by model number. Is there an easy way to do this?
Offline  
Old 06-20-2008, 08:39 PM   #2 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

In the BlackBerry Manager add the column for Model. You can export the list.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 06-20-2008, 09:44 PM   #3 (permalink)
New Member
 
Join Date: Jun 2008
Model: 8310
PIN: N/A
Carrier: Tmo
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

That will do it for one server, but we run several servers across multiple domains nationwide. What I need is a way to do it for the entire system; preferrably in a SQL query.

EDIT: I should have said BESes instead of "a BES"
Offline  
Old 06-20-2008, 10:03 PM   #4 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

Welcome to the forums.

Do the servers share the same database?
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-20-2008, 10:36 PM   #5 (permalink)
New Member
 
Join Date: Jun 2008
Model: 8310
PIN: N/A
Carrier: Tmo
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

There are a few different SQL servers for each domain.
Offline  
Old 06-20-2008, 10:39 PM   #6 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

Someone else may know how to do one SQL query for all of them, unfortunately, I don't.

I use a tool called Query Express (a one file program) to run queries against my 4 servers. The query is actually quite easy to write - the one I use for device information is:

select
DisplayName,
ModelName,
PhoneNumber,
PIN,
IMEI,
AppsVer,
PhoneNumber,
ITPolicyName,
HomeNetwork
from vHandheldSummaryInfo
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-21-2008, 06:31 AM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Take ^ query ... perhaps add in a field from another table that'll indicate which BES they're on and then run the query against all the BESMgmt databases.

Have you looked to consolidate your management databases?
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

70x 1400v 13nF 1302 high voltage polypropylene film capacitors MMC
$20.0
70x 1400v 13nF 1302 high voltage polypropylene film capacitors MMC pictureKikusui TOS9213S withstanding voltage and insulation resistance tester
$5880.0
Kikusui TOS9213S withstanding voltage and insulation resistance tester picture3X Mini DC 5-120V Voltmeter LED Panel 3-Digital Display Voltage Meter 2-wire
$2.99
3X Mini DC 5-120V Voltmeter  LED Panel 3-Digital Display Voltage Meter 2-wire pictureADR433BR - ADR433 Ultralow Noise XFET Voltage Reference IC
$16.88
ADR433BR - ADR433 Ultralow Noise XFET Voltage Reference IC pictureAPT6040AN == APT6040 HIGH VOLTAGE POWER MOSFETS IC
$7.8
APT6040AN == APT6040 HIGH VOLTAGE POWER MOSFETS IC picture






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