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

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' ) )