BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 02-15-2007, 09:18 AM   #1
hayabusa
Talking BlackBerry Encyclopedia
 
hayabusa's Avatar
 
Join Date: Aug 2006
Location: Kansas
Model: 9000
Carrier: Cingular
Posts: 251
Cool DST and SQL table lookup

Please Login to Remove!

Does anyone know if it would be possible to just query a table in the sql table and poll how many of my devices have updatad. I have been trying to roll through the tables to find our what table holds the options menu or what table holds the applications on these devices
Offline  
Old 02-15-2007, 10:18 AM   #2
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Default

DST2007Query.exe is suppose do to that. You can checkout the sticky regarding this topic.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 02-15-2007, 12:53 PM   #3
hayabusa
Talking BlackBerry Encyclopedia
 
hayabusa's Avatar
 
Join Date: Aug 2006
Location: Kansas
Model: 9000
Carrier: Cingular
Posts: 251
Default

yeah I know the query tool is suppose to do this but I am also wanting to know what tables applications are in for auditing purposes in my enviroment any clue
Offline  
Old 02-15-2007, 02:14 PM   #4
mahoward
CrackBerry Addict
 
mahoward's Avatar
 
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Default

I found the module info in the SyncDeviceMgmt table, under the data field. You might want to filter for contains "timezone" on this field otherwise you will get a lot of data back.
Offline  
Old 02-15-2007, 02:22 PM   #5
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Default

You can also find it in the view "vHandheldInfo" in the Data column.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 02-15-2007, 04:57 PM   #6
hayabusa
Talking BlackBerry Encyclopedia
 
hayabusa's Avatar
 
Join Date: Aug 2006
Location: Kansas
Model: 9000
Carrier: Cingular
Posts: 251
Default

if you query by SyncDeviceMgmt where Data=net_rim_bb_timezoneotapatche this will get you how many devices have ran this Thanks for everyones help on this
Offline  
Old 02-15-2007, 05:00 PM   #7
jibi
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
Default

P.S. - Please do not steal avatars from other people, ESPECIALLY when they have their name on it, and ESPECIALLY when it's a forum leader. Thanks.
__________________
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  
Closed Thread



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Vintage Commodore Amiga A500 Computer System w/Mouse Power Supply & WB 1.3 Disk picture

Vintage Commodore Amiga A500 Computer System w/Mouse Power Supply & WB 1.3 Disk

$324.00



Commodore Amiga 2000 Model A2000 Computer  No Video Sold As Is picture

Commodore Amiga 2000 Model A2000 Computer No Video Sold As Is

$499.00



Commodore Amiga 2000 Model A2000 Computer  No Video Sold As Is picture

Commodore Amiga 2000 Model A2000 Computer No Video Sold As Is

$499.00



Commodore Amiga 2000 GVP A2000-030 Combo  (40Mhz) 8mb Ram Rev.3 W/ Caddy & Cable picture

Commodore Amiga 2000 GVP A2000-030 Combo (40Mhz) 8mb Ram Rev.3 W/ Caddy & Cable

$499.00



Jelenko Commodore LS VPF with Pump  picture

Jelenko Commodore LS VPF with Pump

$875.00



Vintage Printer Switch box Commodore 64/Sanyo Mountable Computer PC picture

Vintage Printer Switch box Commodore 64/Sanyo Mountable Computer PC

$49.00







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