[e2matt]

I'm looking to generate a list of devices that have not had any communication since < 'xxxx-xx-xx'. I can't seem to find a table on the BES SQL DB that has this data but it is available in BES when viewing device properties > status.

Anyone have any suggestions?

[knottyrope]

SQL Query to pull "Last Connected" - Port3101.org : Your BES Connection

[MikeB]

I used :

SELECT US.LastContactTime, UC.MailBoxSMTPAddr, UC.CreationTime FROM UserStats US
INNER JOIN UserConfig UC ON UC.id = US.UserConfigId
ORDER BY US.LastContactTime

[juwaack68]

I use this one:

select 
 a.DisplayName,
 a.mailboxsmtpaddr,
 c.ModelName,
 c.VendorID,
 c.AppsVer,
 c.PhoneNumber,
 c.PIN,
 c.HomeNetwork,
 convert(varchar(10),a.CreationTime, 101)CreationDate,
 convert(varchar(10),a.ActivationTime, 101)ActivationDate, 
 b.MsgsForwarded,
 b.MsgsSent,
 convert(varchar(10),b.LastFwdTime, 101)LastFwdDate,
 convert(varchar(10),b.LastSentTime, 101)LastSentDate
 from userconfig a, userstats b, vHandheldSummaryInfo c
 where a.id = b.userconfigid and a.displayname = c.displayname
 order by a.displayname