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  




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