BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-30-2007, 10:28 AM   #1 (permalink)
New Member
 
Join Date: Oct 2007
Model: 7100
PIN: N/A
Carrier: vodafone
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default How to generate a blackberry report

Please Login to Remove!

Hi there,

is there anyone knows how to genereate a report for Blackberry users who havn't used their backberry for over a period of time.

Thanks,
Shaf
Offline  
Old 10-30-2007, 10:29 AM   #2 (permalink)
Crimson Tide Moderator
 
JSanders's Avatar
 
Join Date: Oct 2004
Location: North of the moss line
Model: Z30
OS: 7.0sumtin
PIN: t low
Carrier: Verizon
Posts: 41,920
Post Thanks: 61
Thanked 255 Times in 184 Posts
Default

Welcome to the Forums.

**moving to BES admins section**
Offline  
Old 10-30-2007, 11:02 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Model: 8830
Carrier: Verizon
Posts: 144
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi shaf,

If your BES uses a SQL server to store its data (not the MDSE database) and you have access to the SQL server and the BlackBerry database, you can query the UserStats and UserConfig tables to look at either the LastFwdTime or LastSentTime to determine if someone hasn't communicated in a while.

There was a recent post from hdawg about getting a user dump from the BES if you have the Resource Kit installed and running on your BES. I'm not familiar with the capabilities of the reporting, but I suspect you can also get the data you are looking for there as well.

fbrimm
Offline  
Old 10-30-2007, 11:35 AM   #4 (permalink)
BlackBerry Extraordinaire
 
Frank Castle's Avatar
 
Join Date: Jul 2005
Location: MA
Model: 9930
PIN: PM Me!
Carrier: VZW
Posts: 1,073
Post Thanks: 0
Thanked 4 Times in 3 Posts
Default

BES 4.1

Highlight all the users, or select the ones you'd like and right click and EXPORT STATS to File, then take that and import into Excel to massage the data. I sort by last contact and delete everyone outside the reporting requirement (30 days since use), I added a column in excel and use a basic formula that multiplys every 30 days x $40 (data charge) ..

It helps with large environments if you put your users in groups so your not dealing with huge spreadsheets.
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

Watts Bronze Pressure Vacuum Breaker
$142.99
Watts  Bronze  Pressure Vacuum Breaker pictureWatts Bronze Pressure Vacuum Breaker
$126.99
Watts  Bronze  Pressure Vacuum Breaker pictureBell in vacuum jar sound physics demonstration demo water boil air pressure New
$62.9
Bell in vacuum jar sound physics demonstration demo water boil air pressure New pictureArrowhead Brass Brass Pressure Vacuum Breaker
$9.99
Arrowhead Brass  Brass  Pressure Vacuum Breaker pictureArrowhead Brass Brass Pressure Vacuum Breaker
$18.99
Arrowhead Brass  Brass  Pressure Vacuum Breaker picture






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