BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 05-30-2008, 06:52 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2007
Location: UK
Model: 9000
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Extracting Data for report

Please Login to Remove!

Hi need a small bit of help we are running BES 4.14 on SQL database. I need to extract a report listing User / Number / Model / PIN NO

Any ideas would be helpful
Offline  
Old 05-30-2008, 07:21 AM   #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,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

I use a very handy handy tool called Query Express right from my PC to connect to the remove SQL BESMgmt database (a monkey I know told me about it).

Then I just run a script against the BESMgmt database with the following parameters:

select
DisplayName,
ModelName,
PhoneNumber,
PIN,
IMEI,
AppsVer,
PhoneNumber,
ITPolicyName,
HomeNetwork
from vHandheldSummaryInfo

Works like a charm and can be exported to Excel. Here is a link about Query Express: Download Query Express
__________________
No longer a BES Admin, but it was fun while it lasted!

Last edited by juwaack68 : 05-30-2008 at 07:22 AM.
Offline  
Old 05-30-2008, 08:29 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2007
Location: UK
Model: 9000
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

you star owe you a beer saved me loads of work!! Thanks
Offline  
Old 05-30-2008, 09:01 AM   #4 (permalink)
BlackBerry Extraordinaire
 
Frank Castle's Avatar
 
Join Date: Jul 2005
Location: MA
Model: 9930
PIN: PM Me!
Carrier: VZW
Posts: 1,073
Post Thanks: 0
Thanked 4 Times in 3 Posts
Default

BlackberryReports by Big Phil will do this without having to code SQL query. As well BerryStats so you can get the reporting aspect to the people who care about it and can run reports to their hearts content.

I also belive the basic BES exports will provide that info.
Offline  
Old 07-11-2008, 01:03 PM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2008
Location: Massachusetts
Model: 8830
PIN: N/A
Carrier: Sprint PCS - Simply Everything Baby!
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Does anyone have any information on their experiences with SQL Reporting and the BES? I'm wondering if it's ok to use the BES DB for querying purposes or for SQL reporting (services as well) or if it's recommended that you do not run quieries against the BES DB and rather export the data and then execute against that table.
Offline  
Old 07-11-2008, 01:08 PM   #6 (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

... its fine. Read all you want from the BES Configuration Database ... I'd recommend against writing to it however.
Offline  
Old 07-11-2008, 01:12 PM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2008
Location: Massachusetts
Model: 8830
PIN: N/A
Carrier: Sprint PCS - Simply Everything Baby!
Posts: 19
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks HDawg.
__________________
Equipped with BES 4.1.4 MR3, JLoader, BRK, Simulators, and a can of whoop ***. Let's get things cracking in here.
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

ADVANTECH MOTHERBOARD PCM-9577F-00A3E EMBEDDED COMPUTING
$329.99
ADVANTECH MOTHERBOARD PCM-9577F-00A3E EMBEDDED COMPUTING pictureYAMATO SCALE EV948FR3 MOTHER BOARD
$649.99
YAMATO SCALE EV948FR3 MOTHER BOARD picture motherboard xike
$5.0
 motherboard xike pictureWATER TRANSFER HYDROGRAPHIC FILM HYDRO DIP HYDRO-DIPPING FILM MOTHERBOARD 1SQ
$15.97
WATER TRANSFER HYDROGRAPHIC FILM HYDRO DIP HYDRO-DIPPING FILM MOTHERBOARD 1SQ pictureBrass Motherboard Standoff Stand-off Spacer 116pcs M2 Female Thread F4N8
$1.9
Brass Motherboard Standoff Stand-off Spacer 116pcs M2 Female Thread F4N8 picture






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