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

Colts Indianapolis NFL waitress server waiter waist apron 3 pockets
$12.0
Colts Indianapolis NFL waitress server waiter waist apron 3 pockets pictureBlack apron Wine bottles & fruit waitress server waiter waist apron 3 pockets
$11.0
Black apron Wine bottles  & fruit waitress server waiter waist apron 3 pockets pictureBlue despicable minions waitress server waiter waist apron 3 pockets
$12.0
Blue despicable minions  waitress server waiter waist apron 3 pockets pictureBlack apron Alzheimer's purple ribbon waitress server waiter waist 3 pockets
$11.0
Black apron Alzheimer's purple ribbon waitress server waiter waist 3 pockets pictureBlack apron Frozen sparkle waitress server waiter waist apron 3 pockets
$11.0
Black apron Frozen sparkle waitress server waiter waist apron 3 pockets  picture






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