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

OEM BULB with Housing for DELL 725-10331 Projector with 180 Day Warranty
$319.0
OEM BULB with Housing for DELL 725-10331 Projector with 180 Day Warranty pictureOEM BULB with Housing for DELL 7700 FullHD Projector with 180 Day Warranty
$319.0
OEM BULB with Housing for DELL 7700 FullHD Projector with 180 Day Warranty pictureOEM BULB with Housing for DELL 725-10323 Projector with 180 Day Warranty
$319.0
OEM BULB with Housing for DELL 725-10323 Projector with 180 Day Warranty pictureDell NF485 Black Toner Cartridge 1815dn - NEW - GENUINE - OEM
$55.0
Dell NF485 Black Toner Cartridge 1815dn - NEW - GENUINE - OEM pictureDell OEM Precision T3500 500w Power Supply D525AF-00 DPS-525FB M821J (D4)
$90.0
Dell OEM Precision T3500 500w Power Supply D525AF-00  DPS-525FB  M821J   (D4) picture






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