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

Assorted Vintage Specialty Hand Tools - Matco,Mac,Tail Pipe Cutter, Chain Wrench
$96.0
Assorted Vintage Specialty Hand Tools - Matco,Mac,Tail Pipe Cutter, Chain Wrench pictureNew Vintage Velocette MAC Raw 1948 to 1953 Petrol Fuel Gas Tank
$280.0
New Vintage Velocette MAC Raw 1948 to 1953 Petrol Fuel Gas Tank pictureMAC Tools Steel Punch SMR6 Vintage USA
$5.99
MAC Tools Steel Punch SMR6 Vintage USA pictureVINTAGE MAC CHALLENGER TOOL 80100
$39.99
VINTAGE MAC CHALLENGER TOOL 80100   pictureVintage Mac Tools ET-390 Electrical Systems Analyzer - Good Working Condition -
$39.99
Vintage Mac Tools ET-390 Electrical Systems Analyzer - Good Working Condition -  picture






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