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

OEM BULB with Housing for DELL 310-8290 Projector with 180 Day Warranty
$203.0
OEM BULB with Housing for DELL 310-8290 Projector with 180 Day Warranty pictureOEM BULB with Housing for DELL 1800MP Projector with 180 Day Warranty
$203.0
OEM BULB with Housing for DELL 1800MP Projector with 180 Day Warranty pictureGenuine OEM Dell Ink Cartridge Color Black 7Y745 7Y743 Lot Of 4 +
$39.0
Genuine OEM Dell Ink Cartridge Color Black 7Y745 7Y743 Lot Of 4 + pictureDell Genuine Original LA65NS2-01 65W Laptop AC Adapter - OEM
$18.49
Dell Genuine Original LA65NS2-01 65W Laptop AC Adapter  -  OEM pictureDell OEM 5100 series 4 Color Toner Set CMYK, GG577, GG578, GG579, HG308 - New
$179.99
Dell OEM 5100 series 4 Color Toner Set CMYK, GG577, GG578, GG579, HG308 - New picture






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