View Single Post
Old 05-13-2008, 08:40 AM   #9 (permalink)
Grimlin
CrackBerry Addict
 
Grimlin's Avatar
 
Join Date: Jun 2005
Location: Signal Mountain, TN
Model: 9900
PIN: Positive Intrinsic Negative???
Carrier: at&t
Posts: 728
Post Thanks: 1
Thanked 4 Times in 4 Posts
Default

Created three new ITPolicies on the BES for Unite.
  • Bluetooth - enables bluetooth desktop connection and wireless bypass
  • Tracking - Tells devices to report their GPS location back to the Unite server on 15min intervals
  • Bluetooth and tracking - Duh

BCP Export:
Code:
bcp "SELECT * FROM ITPolicy2 Where ID > 5" queryout C:\Docume~1\username\Desktop\ITPolicy2.txt -S server\instance -T
This exported the binary data and I can use it in reverse to insert the data into the Unite server. The ID > 5 was just the easiest way to specify which ones I wanted. Your query will vary.

Here is the table structure we are dealing with:
Code:
9.0
8
1       SQLINT        0       4       ""   1     Id                                                     ""
2       SQLCHAR       2       128     ""   2     PolicyName                                             SQL_Latin1_General_CP1_CI_AS
3       SQLINT        0       4       ""   3     AllowOtherEmailServices                                ""
4       SQLINT        0       4       ""   4     AllowOtherBrowserServices                              ""
5       SQLIMAGE      4       0       ""   5     HandheldBlob                                           ""
6       SQLIMAGE      4       0       ""   6     DesktopBlob                                            ""
7       SQLINT        1       4       ""   7     SessionId                                              ""
8       SQLBINARY     2       8       ""   8     Lurnum                                                 ""


When I get home tonight, I will import them into Unite and post the results.

Again, this information is just for the few nerds that want to follow along. When I am done and it is tested, I will try to post files and concise instructions.
__________________
BlackBerry® Certified Support Specialist

Tri-wielding Z10/9900/9670
9810,9800,9700,8220,9000,8820,8800,7270,
8700c,7290,7230,7510,6510,5810,957,857,950
Offline   Reply With Quote