Thanks for the tip! I imported data from the UserConfig table onto a second sheet and then added a VLOOKUP to a column on the first sheet to look up the user names.
Anthony From: "Wesson, Michael" <[email protected]> To: <[email protected]>, "A list for BES Admin's to discuss issues, etc." <[email protected]> Date: 02/22/2011 06:44 PM Subject: Re: [Bes-admins] Enterprise Location Tracking Sent by: [email protected] No problems. There is a bit of manual work to be done to actually track where the device is on the planet, but here are the steps I took. I'm also using Excel 2010. Open Excel Click on the Data tab in the Ribbon Click From other sources - From SQL Server Enter in your SQL server name and credentials if required, click Next Select your BlackBerry database Choose the SyncLBS table, click Next Click next then finish This should give you the following (generic details in the table): Id UserConfigId RecordType RecordTimestamp ServerTime Latitude Longitude Altitude DeviceStatus Data 1 1 1 0 1295500007 0 0 0 0 6 3 1 0 1296514986 0 0 0 0 4 22 1 0 1294876436 0 0 0 0 5 23 1 0 1294876665 0 0 0 0 2 26 1 0 1289522205 0 0 0 0 3 31 1 0 1292553189 0 0 0 0 UserConfigID is the UserID on the BES server, I’ve only done manual match ups here. The Latitude and Longitude are strings, you’ll need to enter decimal points manually. You can then use www.findlatitudeandlongitude.com to locate the device on the planet. I’m still working on how to better match the UserConfigID with the real user account name, and a better method of displaying latitude and longitude. Cheers, Michael Wesson | Systems Engineer News Limited | National IT – Service Operations -----Original Message----- From: [email protected] [ mailto:[email protected]] On Behalf Of Jacob Shields Sent: Wednesday, 23 February 2011 2:42 AM To: A list for BES Admin's to discuss issues,etc. Subject: Re: [Bes-admins] Enterprise Location Tracking Agreed there, it'd be some good information from the group. Thank You, Jacob Shields Partner Chief Information Officer http://www.buzzworthyconsulting.net [email protected] Michigan Office: 906.828.9194 Cell: 906.396.7861 "Sent from my Verizon Wireless BlackBerry" ------------------------------------------------------------------ NOTICE: The information contained in this message is intended only for the above named and confidential use of the recipient(s). If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and destroy all copies of this message. No virus found in this incoming message. -----Original Message----- From: Darhl Thomason <[email protected]> Sender: [email protected] Date: Tue, 22 Feb 2011 07:29:32 To: A list for BES Admin's to discuss issues, etc.<[email protected]> Reply-To: "A list for BES Admin's to discuss issues, etc." <[email protected]> Subject: Re: [Bes-admins] Enterprise Location Tracking Better just send it to the list, I'm interested as well :-) Darhl Thomason | SysAdmin | Business Technology Papa Murphy’s Int'l. | d 360-449-4044 | c 360-607-5617 | www.papamurphys.com -----Original Message----- From: [email protected] [ mailto:[email protected]] On Behalf Of Marko Popovic Sent: Tuesday, February 22, 2011 7:28 AM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Enterprise Location Tracking Michael, Could you please email it to me too? Thanks! Marko Sent from my BlackBerry® smartphone from Vodafone -----Original Message----- From: "Taggart, Mike" <[email protected]> Sender: [email protected] Date: Tue, 22 Feb 2011 09:05:27 To: A list for BES Admin's to discuss issues, etc.<[email protected]> Reply-To: "A list for BES Admin's to discuss issues, etc." <[email protected]> Subject: Re: [Bes-admins] Enterprise Location Tracking Michael, Could you email me directly the steps you took to make this work? I'm curious to see what information we can pull. Thanks, Mike -----Original Message----- From: [email protected] [ mailto:[email protected]] On Behalf Of Wesson, Michael Sent: Monday, February 21, 2011 7:05 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Enterprise Location Tracking Brilliant, works perfectly!!! Michael Wesson | Systems Engineer News Limited | National IT – Service Operations -----Original Message----- From: [email protected] [ mailto:[email protected]] On Behalf Of Decker, Winfield R. CTR NNMC Sent: Saturday, 5 February 2011 4:30 AM To: A list for BES Admin's to discuss issues,etc. Subject: Re: [Bes-admins] Enterprise Location Tracking You can use Excel 2003/2007 and use the OBDC connection to SQL and perform your query that way. I do believe it works the same in MYSQL as SQL. ______________________________________________ Bes-Admins mailing list [email protected] http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins --------------------------------- ------------------------------------------------------------------------------------ "#1 Rated Pizza Chain" - ZAGAT 2010 National Restaurant Chains Survey This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to the addressee, you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently delete this message and its attachments and kindly notify the sender by reply e-mail. Any content of this message and its attachments which does not relate to the official business of the sending company must be taken not to have been sent or endorsed by that company or any of its related entities. No warranty is made that the e-mail or attachments are free from computer virus or other defect. _______________________________________________ Bes-Admins mailing list [email protected] http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins --------------------------------- Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
_______________________________________________ Bes-Admins mailing list [email protected] http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins --------------------------------- Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
