BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-21-2010, 09:34 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2010
Model: 8520
PIN: N/A
Carrier: VODAFONE
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default When user setup on BES

Please Login to Remove!

Have got over 750 users and using cyrstal to analyse the data and produce reports. Need to figure out the field tha shows when a user was activated as i am not convinced alot are used regularly.
Offline  
Old 07-21-2010, 09:39 AM   #2 (permalink)
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,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

What version of BES are you using, and what platform?

For Exchange, there is a field in the userconfig table called ActivationTime you can use. Here a query I use that may help you out:

Code:
select 
 a.DisplayName,
 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
 where a.id = b.userconfigid
 order by a.displayname
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 07-21-2010, 10:11 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2010
Model: 8520
PIN: N/A
Carrier: VODAFONE
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

im using 4.6 on exchange however i dont touch the exchange environment

hence i am using an odbc connection to the db and linking it to crystal reports to read the data.

I can see all the tables however not to sure where the field for activation is held
Offline  
Old 07-21-2010, 10:20 AM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2010
Model: 8520
PIN: N/A
Carrier: VODAFONE
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

found it

Under vUserConfigStats select Activation time

Thanks juwaack68
Offline  
Old 07-28-2010, 08:26 AM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2010
Model: 8520
PIN: N/A
Carrier: VODAFONE
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

managed to pull out stats on when the user was activated and how much they actually used their device. Our 80 users not used their devices for more then 2 weeks after activation. Do other BES admins find this. What a waste of money
Offline  
Old 07-28-2010, 08:31 AM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,609
Post Thanks: 6
Thanked 122 Times in 119 Posts
Default

We sort by "Last contact time" in the BES Management console (4.1.7 MR3). Anyone that had no contact for more than 3 months must either have a good explanantion or give the device back.
Offline  
Old 07-28-2010, 08:54 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2010
Model: 8520
PIN: N/A
Carrier: VODAFONE
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

you get many?
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

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

GE RF AMP Radio Frequency Amplifier Board 2260212-C for Logiq 9 Ultrasound
$399.99
GE RF AMP Radio Frequency Amplifier Board 2260212-C for Logiq 9 Ultrasound pictureEG&G Ortec 450 Research Amplifier NIM BIN Plug-In Rack Module Unit Industrial
$699.99
EG&G Ortec 450 Research Amplifier NIM BIN Plug-In Rack Module Unit Industrial pictureVintage Sperry Gyroscope 1777590 Servo Amplifier Amp Test Set Unit PARTS
$54.99
Vintage Sperry Gyroscope 1777590 Servo Amplifier Amp Test Set Unit PARTS pictureHP Agilent A2 05340-60092 Pre Amplifier Assembly #2 Unit Module Industrial
$112.99
HP Agilent A2 05340-60092 Pre Amplifier Assembly #2 Unit Module Industrial pictureBouche 2114F Precision Charge Amplifier Amp Comparison Shock Calibration Module
$55.99
Bouche 2114F Precision Charge Amplifier Amp Comparison Shock Calibration Module picture






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