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

300 pcs Transistor MPSA 42 MPSA42 MPS-A42 TO-92
$8.78
300 pcs Transistor MPSA 42 MPSA42 MPS-A42 TO-92 pictureMOTOROLA 2N4852 UNIJUNCTION SI TO-18 TRANSISTOR - YOU GET 10 PIECES
$7.95
MOTOROLA 2N4852 UNIJUNCTION SI TO-18 TRANSISTOR - YOU GET 10 PIECES pictureWorking B&K 970 Transistor Equipment Analyst.
$85.0
Working B&K 970 Transistor Equipment Analyst. pictureLCR-T4 ESR Meter Transistor Tester Diode Triode Capacitance SCR Inductance New
$7.95
LCR-T4 ESR Meter Transistor Tester Diode Triode Capacitance SCR Inductance New picture1Pcs At89c2051-24Pu At89c2051 At89c2051 Dip-20 Atmel Microcontroller New Ic E
$0.99
1Pcs At89c2051-24Pu At89c2051 At89c2051 Dip-20 Atmel Microcontroller New Ic E picture






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