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: 9xx0
OS: 7.0sumtin
PIN: t low
Carrier: Verizon
Posts: 41,907
Post Thanks: 60
Thanked 244 Times in 182 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





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