BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-24-2010, 04:10 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2010
Model: 8310
PIN: N/A
Carrier: AT&T
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Show Installed Modules, Version , LastContact Date

Please Login to Remove!

Greetings all,

I have some SQL that shows me the version installed for a particular application.

But I am hoping to add last contact date to the query.

I am not sure if this SQL is quite correct. I don't see Last Contact Date when I run the query. Is it possible that the field exists in another table?

SELECT userconfig.id,
userconfig.displayname,
userconfig.username,
userconfig.pin,
syncdevicemgmt.modulename,
syncdevicemgmt.moduleversion,
userconfig.otafmnextsynctime,
userstats.lastcontacttime
FROM syncdevicemgmt,
userconfig,
userstats
WHERE ( userconfig.id = syncdevicemgmt.userconfigid ) and
( userstats.id = syncdevicemgmt.userconfigid ) and
( ( SyncDeviceMgmt.ModuleName = 'FTLJAVA' ) )


Thanks!!

Paul
Offline  
Old 10-24-2010, 04:29 PM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2010
Model: 8310
PIN: N/A
Carrier: AT&T
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Show Installed Modules, Version , LastContact Date

I think I figured it out. But not sure if it is the right value...

The following SQL gives what appears to be the last contact date/time using field userstats.lastsenttime. Does anyone know if this is the last date/time that BES 'attempted' to contact the device, or is is that last date/time that BES actually made contact?

Thanks!!

Paul

SELECT userconfig.id,
userconfig.displayname,
userconfig.username,
userconfig.pin,
syncdevicemgmt.modulename,
syncdevicemgmt.moduleversion,
userconfig.otafmnextsynctime,
userstats.lastsenttime
FROM syncdevicemgmt,
userconfig,
userstats
WHERE ( userconfig.id = syncdevicemgmt.userconfigid ) and
( userstats.userconfigid = syncdevicemgmt.userconfigid ) and
( ( SyncDeviceMgmt.ModuleName = 'FTLJAVA' ) )
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

New HP Proliant DL380 Gen4/ML370 Server Intel Xeon Processor 311584-B21
$41.99
New HP Proliant DL380 Gen4/ML370 Server Intel Xeon Processor 311584-B21 pictureATCA SBC-G-TKT300-300 MPCBL0040N02Q 2Ghz Xeon
$1000.0
ATCA SBC-G-TKT300-300 MPCBL0040N02Q 2Ghz Xeon  pictureSUPERMICRO X5DA8 DUAL 3GHZ XEON MOTHERBOARD W/CPU+HSF+2GBRAM+IO SHIELD
$399.99
SUPERMICRO X5DA8 DUAL 3GHZ XEON MOTHERBOARD W/CPU+HSF+2GBRAM+IO SHIELD  pictureLOT OF 2 INTEL XEON SLACB CPU/MICROPROCESSORS E5310
$19.99
LOT OF 2 INTEL XEON SLACB CPU/MICROPROCESSORS E5310 pictureDELL PRECISION 490 WORKSTATION XEON 5160 3GHZ/8GB/QUADRO FX/XPPRO COA
$149.99
DELL PRECISION 490 WORKSTATION XEON 5160 3GHZ/8GB/QUADRO FX/XPPRO COA picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.