BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 02-15-2012, 05:20 PM   #1
e2matt
New Member
 
Join Date: Aug 2010
Model: 8530
PIN: N/A
Carrier: Telus
Posts: 3
Default SQL Query find Last Com. Time

Please Login to Remove!

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?
Offline  
Old 02-15-2012, 05:43 PM   #2
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
Default Re: SQL Query find Last Com. Time

SQL Query to pull "Last Connected" - Port3101.org : Your BES Connection
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 02-20-2012, 01:58 PM   #3
MikeB
Thumbs Must Hurt
 
Join Date: Feb 2005
Location: Canada
Model: 8830
Carrier: BELL
Posts: 65
Default Re: SQL Query find Last Com. Time

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
__________________
7 Bes Servers on Domino
4000 Satisfied Users
Offline  
Old 02-20-2012, 02:10 PM   #4
juwaack68
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,878
Default Re: SQL Query find Last Com. Time

I use this one:

Code:
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
__________________
No longer a BES Admin, but it was fun while it lasted!
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads for: SQL Query find Last Com. Time
Thread Thread Starter Forum Replies Last Post
MDS application devlopment HELP! - MS SQL database query dipen Developer Forum 0 09-14-2009 03:13 AM
Sync Error....What could it be? kurrupt_1 General 8300 Series Discussion - Curve 7 11-22-2007 07:41 PM
DB Upgrade Failed. Error Executing SQL statement SimonMac BES Admin Corner 18 09-27-2007 08:03 AM
Database Backup...and restore. how? alwayzurboy BES Admin Corner 8 07-03-2007 07:24 AM


Grandstream WP810 Dual Band Portable Wi-Fi Phone Voip Phone and Device- picture

Grandstream WP810 Dual Band Portable Wi-Fi Phone Voip Phone and Device-

$42.95



Mitel 5330e Enhanced Gigabit (50006476) BACKLIT Display POE IP NEW picture

Mitel 5330e Enhanced Gigabit (50006476) BACKLIT Display POE IP NEW

$139.00



CyberData 011233 SIP VoIP Paging Adapter NEW in Box picture

CyberData 011233 SIP VoIP Paging Adapter NEW in Box

$259.00



Viking E-30-IP Handsfree VoIP Entry Phone with Autodialer New Open Box picture

Viking E-30-IP Handsfree VoIP Entry Phone with Autodialer New Open Box

$249.99



Cisco CP-8811-K9 Unified Office IP VoIP PoE Business Phone w/ Stand & Handset picture

Cisco CP-8811-K9 Unified Office IP VoIP PoE Business Phone w/ Stand & Handset

$14.99



Allworx Verge 9312 Color VoIP & POE Office Phone with stand. No AC Adapter picture

Allworx Verge 9312 Color VoIP & POE Office Phone with stand. No AC Adapter

$99.99







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