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





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