Greetings,

Does anyone have an SQL query that will list the basic User/Blackberry information (ie User Name, Pin, Device model) along with the Last Contacted date and sorted by "Last Contact Date"? (Even if the field is blank, I need the user record to show on the report)? I would greatly appreciate any help on this issue. I

Thanks in advance
Wolfar

Try the attached.

The actual field 'LastContactTime' (UserStats), returns NULL, so I use 'LastFwdDate' -

Attached Files

BBStatsByLastFwdTime.txt (795 Bytes, 120 views)

Last Contact seems to be a formula which displays the more recent of "last sent" vs "last received"

So if you can do a pull of last sent and last received, and have something compare the two, you'd get last contact.