View Single Post
Old 07-22-2008, 07:48 AM   #21
DavidAdams
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Default

Please Login to Remove!

The UserConfigID is a link to the ID field in the UserConfig table, which in turn wil give you user names.

I use QueryExpress to run very quick queries over my BESMgmt, so much faster than the Manager to keep a quick eye on whose BB hasn't connected recently.

This is the sql query itself:
Code:
select
Latitude,
Longitude,
UserConfigID,
DisplayName,
PIN
FROM SyncLBS JOIN UserConfig
ON SyncLBS.UserConfigID = UserConfig.Id
Output is a list of Latitude, Longitude, UserConfig IDs, Names and their PIN, least I am assuming that will give you the detail you require as I haven't done the actual upgrades yet I dont actually have any data returned.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone

Last edited by DavidAdams; 07-22-2008 at 07:53 AM..
Offline   Reply With Quote