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

Opticon OPN-3002I 2D CMOS Imager, Supports Apple iOS, Android, Blackberry and
$515.82
Opticon OPN-3002I 2D CMOS Imager, Supports Apple iOS, Android, Blackberry and pictureHouse of Doolittle EcoTones Monthly Desk Pad Calendar Blackberry
$30.99
House of Doolittle EcoTones Monthly Desk Pad Calendar Blackberry pictureMousepad, Blackberry Design
$7.99
Mousepad, Blackberry Design picture2pcs Mini 5pin Female Blackberry USB Jack Charger Port
$0.01
2pcs Mini 5pin Female Blackberry USB Jack Charger Port picturePremium Elbow Length Gloves for Thorns, Rose Gloves, Cactus Gloves, Blackberry
$22.89
Premium Elbow Length Gloves for Thorns, Rose Gloves, Cactus Gloves, Blackberry picture






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