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,128
Post Thanks: 352
Thanked 352 Times in 329 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 10 running sweet for my Passport, Z30, Z10 and Q10
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  
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

Tektronix TPP1000 Passive Voltage Oscilloscope Probe 14 Day Warranty
$230.0
Tektronix TPP1000 Passive Voltage Oscilloscope Probe 14 Day Warranty pictureTektronix TAP2500 2.5 GHz Active Voltage Probe * 14 DAY WARRANTY*
$330.0
Tektronix TAP2500 2.5 GHz Active Voltage Probe * 14 DAY WARRANTY* pictureTektronix P7240 4 GHz High Performance Active Voltage Probe TekConnect w/Acc
$299.0
Tektronix P7240 4 GHz High Performance Active Voltage Probe TekConnect w/Acc picture5pcs TD-62004AP. High Current And Voltage Darlington. 16 Pin DIP. NOS USA
$12.5
5pcs TD-62004AP. High Current And Voltage Darlington. 16 Pin DIP. NOS USA picture5pcs UDN-2580A. High Current And Voltage Source Driver. 18 Pin DIP. USA NOS
$10.0
5pcs UDN-2580A. High Current And Voltage Source Driver. 18 Pin DIP. USA NOS picture






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