BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-08-2009, 08:30 AM   #1 (permalink)
New Member
 
Join Date: Sep 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 4.16 - Automated Device Export??

Please Login to Remove!

I am trying to automate exporting all the device information from the BES. Is there a way to do this with in the 4.16 console? I have tried connecting to the SQL DB but with-out the schema to where all the device information is located this would take a very long time to produce a query that I need. Any help would be greatly appreciated.

I need this information to update my companies asset DB system on a daily basis.

Last edited by astroudjr : 09-08-2009 at 08:32 AM.
Offline  
Old 09-08-2009, 08:49 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,198
Post Thanks: 368
Thanked 374 Times in 344 Posts
Default

Take a look at this

SQL Script to grab user / handheld data - Port3101.org : Your BES Connection
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Old 09-08-2009, 09:40 AM   #3 (permalink)
New Member
 
Join Date: Sep 2009
Model: 8330
PIN: N/A
Carrier: Verizon
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, this is exactly what I needed!!!!
Offline  
Old 09-08-2009, 10:17 AM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Alternatively use Excel to lookup your SQL directly, vUserConfigStats should have most if not all the info you need. That way there is little/no risk to your SQL by a slip in the query statement.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  




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