Wednesday, May 30, 2007

GPS Reporting to BES Server in 4.1 SP3 IT Policy

Upon upgrading to 4.1 SP3, I noticed that the IT Policy has a new Policy Group named "Location Based Services". Under this new group are the following options:



Disable BlackBerry Maps: (Default: False, Requires: Device code 4.0.0 and higher)

Enable Enterprise Location Tracking: (Default: False, Requires: Device code 4.2.1 and higher)

Enterprise Location Tracking User Prompt: (Default: "Your Location is now being tracked at the server", Requires: Device code 4.0.0 and higher)

Enterprise Location Tracking Interval: (Default: 15 Minutes, Requires: Device code 4.2.1 and higher)

I was very excited to see these built in options, which allow tracking via GPS without having to purchase a third party solution. I enabled the tracking, leaving the interval set to 15 minutes, but changing the apparently mandatory notification to "Please call (312) XXX-XXXX to return this device." This serves the purpose of providing some sort of notification, but not letting the user know that their device location is being tracked. I named this policy "Device Tracker" so that I can use this to locate stolen devices, it is not used as a general purpose policy.

I then applied this policy to single user who uses a BlackBerry 8800 device at code level 4.2.1. Everything works great... except for the fact that I have no idea where the GPS information is logged to on the BES server. I would suspect the SQL server in a device related table, but cannot find anything.

I have asked RIM and am awaiting a response... I guess they are not sure either where this information is stored. Once this tiny issue is sorted out I am going to have some fun with Google Maps mashups, making tracking lost or stolen devices that much easier.

3 comments:

Unknown said...

Same here, switches on fine, just not a clue where the data gets written too.

Spoken to BES support and they don't seem to know either....really useful!

Mark said...

Hi Paul, from a thread on BlackBerryForums.com, here is where it is located:

Table: SyncLBS
Columns:
Id
UserConfigId
RecordType
RecordTimestamp
ServerTime
Latitude
Longitude
Altitude
DeviceStatus
Data

Also, "BES 4.1 SP4 policy information has been updated to say it's only compatible with OS 4.2.2 and above. Oh well, looks like they bought themselves a few months to get it working correctly."

Wendy Richards said...

Paul, Mark,

We got caught out by this one too. Spend over a week trying to get this up and running without thinking what the end result would look like. We assumed you would be able to track our employees and view a nice map etc.

After another few weeks of research we used a specialist tracking solution from WatchOverme.co.uk called Watchberry. We recommend these specialist applications as you'll have much more flexibility. Our system is end-to-end encrypted and the tracking servers are located within our own corporate firewalls.

IMHO, until Blackberry get their own version like this then don't bother with the built in BES stuff.