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  




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