BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-15-2006, 02:28 PM   #1 (permalink)
CrackBerry Addict
 
Join Date: Mar 2005
Location: San Francisco
Model: Bold
Carrier: ATT
Posts: 941
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Anyway to pull data from the BES server?

Please Login to Remove!

We need a list of all users, their model, phone #, FW version, wireless carrier etc we can put into an Excel spreadsheet.

When I do the export user stats I just get the name, Pin, messages pending, sent etc.
Offline  
Old 06-15-2006, 02:51 PM   #2 (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

What version BES are you using?
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-15-2006, 02:55 PM   #3 (permalink)
Retired BlackBerryForums.com Moderator
 
d_fisher's Avatar
 
Join Date: Oct 2005
Location: Columbus, OH
Model: 9700
OS: SID 6.7
Carrier: AT&T
Posts: 4,455
Post Thanks: 0
Thanked 2 Times in 1 Post
Default

You can write a query to pull the information you need directly from the SQL database. Might also want to look at BerryStats.
__________________
Doug

Remember, please try searching first!

Need a screenshot? ... Like JavaLoader?
Try using BBscreen .....Use JL_Cmder!
or BBScreenShooter!

[SIGPIC][/SIGPIC]
Offline  
Old 06-15-2006, 02:59 PM   #4 (permalink)
CrackBerry Addict
 
Join Date: Mar 2005
Location: San Francisco
Model: Bold
Carrier: ATT
Posts: 941
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

4.1.0.38
Offline  
Old 06-15-2006, 03:05 PM   #5 (permalink)
New Member
 
Join Date: Jan 2006
Model: 7520
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We're running BES 4.0 SP4 HF#3 and we get that information from the Handheld Configuration Tool. Select all your handhelds, then under Tasks, select Export Asset Summary Data.
Offline  
Old 06-15-2006, 03:06 PM   #6 (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

Which messaging system? If Exchange, you can open Handheld Configuration Tool and export them from there. It will only export what is available, so if the user has completed an enterprise activation, it will have that information (barring any sort of hiccups).
__________________
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 07-05-2006, 10:49 AM   #7 (permalink)
Knows Where the Search Button Is
 
EDDYBLUELEX's Avatar
 
Join Date: Mar 2006
Location: NJ
Model: 7290
Carrier: tmobile
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yup open up configuration tool hit handhelds. Than did a select all by highlightening all the accounts and hit tasks, export to ansi file. Use excel inport wizard. Than open txt file with excel to open delimted commas and tab.
__________________
EDDY EL REY DEL LO REYES
Offline  
Old 07-05-2006, 01:08 PM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2006
Model: 8100t
Carrier: tmobile
Posts: 45
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can make a query in excel using the import external data option under (Data). This is as long as you have reader access to the sql db.

You select the server you are pulling from and then click on the fields.

Or here is a simple sql query for what you are looking

SELECT vHandheldSummaryInfo.DisplayName, vHandheldSummaryInfo.ModelName, vHandheldSummaryInfo.AppsVer, vHandheldSummaryInfo.PhoneNumber, vHandheldSummaryInfo.HomeNetwork, vHandheldSummaryInfo.PIN
FROM BESMgmt.dbo.vHandheldSummaryInfo vHandheldSummaryInfo
Offline  
Old 08-14-2006, 05:59 PM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2006
Location: Brooklyn, NY
Model: 8830
Carrier: Verizon
Posts: 24
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm running BES 4.1 but I have yet to see this Handheld Configuration Tool you all speak of. Is it an optional install?
Offline  
Old 08-14-2006, 06:10 PM   #10 (permalink)
CrackBerry Addict
 
|||||||'s Avatar
 
Join Date: Jun 2006
Model: 7100
Carrier: Rogers
Posts: 615
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by onelikeseabass
I'm running BES 4.1 but I have yet to see this Handheld Configuration Tool you all speak of. Is it an optional install?
In 4.1 it gets included into BlackBerry manager, go under the user list and select all users, go to Device Managment and Export Asset Summary.

I found it by accident one day.
Offline  
Old 08-15-2006, 10:16 AM   #11 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's the thread for BerryStats ---> BerryStats for NonAdmins

We've updated it quite a bit from Brent's original code.

Rob
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ
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.