Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection

LinkBack (1) Thread Tools Display Modes
SQL Query to pull "Last Connected"
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-23-2011, 10:11 AM
BES Activated
Join Date: Mar 2011
Location: North Carolina
Posts: 1
Default SQL Query to pull "Last Connected"


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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-01-2011, 01:53 PM
BES Activated
Join Date: Dec 2009
Location: Seattle, WA
Posts: 9

Try the attached.

The actual field 'LastContactTime' (UserStats), returns NULL, so I use 'LastFwdDate' -
Attached Files
File Type: txt BBStatsByLastFwdTime.txt (795 Bytes, 710 views)
Reply With Quote
  #3 (permalink)  
Old 04-29-2011, 11:50 AM
BES Administrator
Join Date: Jan 2009
Location: Wilmington, DE
Posts: 14

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.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/scripts-tools-hints-tricks/2596-sql-query-pull-last-connected.html
Posted By For Type Date
SQL Query find Last Com. Time - BlackBerry Forums Support Community This thread Refback 04-25-2014 08:53 AM

Similar Threads
Thread Thread Starter Forum Replies Last Post
KB00798 - "CDO not registered" in event viewer on the BlackBerry Enterprise Server hdawg Featured BlackBerry KB Articles 0 09-20-2009 04:12 PM
KB16301 - BES 5.0 installation fails with the error "SQL query failed, see logs ..." hdawg Featured BlackBerry KB Articles 0 07-21-2009 05:30 PM
KB17831 - "Uncaught Exception: java.lang.IllegalArgumentException" on the BlackBerry hdawg Featured BlackBerry KB Articles 0 05-27-2009 10:41 AM
KB16016 - "70 Processing Stopped: Invalid PIN" appears in the IT Policy Status ... hdawg Featured BlackBerry KB Articles 0 05-26-2009 01:59 PM
KB15358 - "Provisioning failed (error 1012)" when attempting to provision a BB hdawg Featured BlackBerry KB Articles 0 01-14-2009 07:45 PM

All times are GMT -4. The time now is 09:33 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2