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.