BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-21-2010, 10: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, 10: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,875
Post Thanks: 3
Thanked 72 Times in 55 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, 11: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, 11: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, 09: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, 09:31 AM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 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, 09: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





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