BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-20-2006, 02:52 PM   #1 (permalink)
New Member
 
Join Date: Mar 2006
Model: 7100
Carrier: AT&T
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating an archive of handheld changes

Please Login to Remove!

This may be a simple Blackberry Enterprise SQL schema question, but we are trying to keep an archive of all handheld changes. There is a SQL table view which is great for tracking cell numbers, BB model numbers, associated users, BB IMEI's, etc..

We already pull active information from this SQL table view (called vHandheldSummaryInfo). Using this SQL table view, it appears that the "ID" column updates/increments everytime a handheld or user change is made. Does anyone know if this is true and if it's the ideal column to key off for archiving?

Here's the sql we are using:

----
INSERT INTO MyHandheldSumArchive
(Id, UserConfigId, ServerTime, ModelName, PlatformVer,
AppsVer, PhoneNumber, IMEI, HomeNetwork, VendorID,
PasswordEnabled, HandheldConfigStatus,
HandheldConfigCheckTime, DCID, FlashSize,
ITPolicyName, ITPolicyTime, PIN, DeviceType,
DisplayName, ServerConfigId, HandheldConfigId,
DeviceCapabilities)
SELECT Id, UserConfigId, ServerTime, ModelName, PlatformVer,
AppsVer, PhoneNumber, IMEI, HomeNetwork, VendorID,
PasswordEnabled, HandheldConfigStatus,
HandheldConfigCheckTime, DCID, FlashSize,
ITPolicyName, ITPolicyTime, PIN, DeviceType,
DisplayName, ServerConfigId, HandheldConfigId,
DeviceCapabilities
FROM vHandheldSummaryInfo
WHERE vHandheldSummaryInfo.id not in
(select distinct MyHandheldSumArchive.id from MyHandheldSumArchive)
----

Any tips or suggestions?
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

20x 24C64 Serial Eeprom SMD TSOP8 Atmel AT24C64
$6.16
20x 24C64 Serial Eeprom SMD TSOP8 Atmel AT24C64 picture20x 93S66 Serial Eeprom SMD SOIC8 STMicro M93S66WMN6T 93C66
$4.28
20x 93S66 Serial Eeprom SMD SOIC8 STMicro M93S66WMN6T 93C66 pictureTNM2000+ USB Universal Programmer+TSOP32/40/48 socket Support EEPROM FLASH GAL
$209.0
TNM2000+ USB Universal Programmer+TSOP32/40/48 socket Support EEPROM FLASH GAL  pictureTNM2000+ USB Universal Programmer+TSOP32/40/48+TSOP56 ic socket for EEPROM CPLD
$253.0
TNM2000+ USB Universal Programmer+TSOP32/40/48+TSOP56 ic socket for EEPROM CPLD pictureCutler-Hammer MPC1A20 EEPROM Cartridge For MPC1 EUC
$26.97
Cutler-Hammer MPC1A20 EEPROM Cartridge For MPC1 EUC picture






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