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

Kleco Tissue Pulverizer Model 2000 Laboratory Cryogenic Grinding Processor
Kleco Tissue Pulverizer Model 2000 Laboratory Cryogenic Grinding Processor pictureConmed Light Source & Processor set
Conmed Light Source & Processor set pictureINDRAMAT CPUB02A01-FW MTCNC CPU MODULE
RECONDITIONED FANUC CPU BOARD A16B-2200-0320 pictureBrother Em 430 Electronic Typewriter Processor.
Brother Em 430  Electronic Typewriter Processor. picture

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