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
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.

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,913
Post Thanks: 59
Thanked 241 Times in 180 Posts

Welcome to the Forums.

**moving to BES admins section**
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

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.

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

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.

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