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,875
Post Thanks: 3
Thanked 72 Times in 55 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,875
Post Thanks: 3
Thanked 72 Times in 55 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





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