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

Advance Programmed Start Fluorescent 120V-277V Electronic Ballast ICN-2S54-T
$19.0
Advance Programmed Start Fluorescent 120V-277V Electronic Ballast ICN-2S54-T pictureJB Vacuum Pump, Gas Ballast Valve with O-Ring, Part# PR-7
$14.35
JB Vacuum Pump, Gas Ballast Valve with O-Ring, Part#  PR-7 picture icehorse cold temperature ballast, ih2-unv-270-t8
$109.97
 icehorse cold temperature ballast, ih2-unv-270-t8 pictureSylvania QTP2X32T8/UNV ISN-SC Electronic Ballast (Lot of 2)NEW
$19.2
Sylvania QTP2X32T8/UNV ISN-SC Electronic Ballast (Lot of 2)NEW pictureLOT 10 NEW OSRAM 49130 QTP-2X54T5HO/UNV-PSN Electronic Fluorescent Light Ballast
$199.99
LOT 10 NEW OSRAM 49130 QTP-2X54T5HO/UNV-PSN Electronic Fluorescent Light Ballast picture






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