BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 01-28-2008, 04:55 PM   #1 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Arrow BES reporting tool

Please Login to Remove!

I am developing a Windows Forms application for me to use to gather reports on certain aspects of my BES environment and was wondering if there is any interest from any other BES Admins? I have read a little about the BerryStats asp application which looks pretty cool, but if you cant run/dont want to run an IIS server then this might work for you. built on .NET 2.0 so that is the requirement to run the app. Does anyone think there might be demand for this?

Here is the new build of the app, but i can add any data that anyone would need to export. Using the FILE MenuStrip you can export the entire grid to a csv file.
Attached Images
File Type: jpg BlackberryReports_1.0.0.6.JPG (88.0 KB, 267 views)
Attached Files
File Type: zip BlackberryReports_1.0.0.7.zip (123.6 KB, 243 views)

Last edited by big.phil : 05-22-2008 at 06:18 PM. Reason: Version 1.0.0.7, Changed output of several columns to be local time instead of UTC, datagrid renders very fast now!
Offline  
Old 01-29-2008, 12:17 AM   #2 (permalink)
New Member
 
Join Date: Jan 2008
Model: 8800
PIN: N/A
Carrier: Vodafone
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES reporting tool

I would be very interested in this. From my point of view it would be useful to point the app at more than one SQL database (preferably query several databases at the same time in one report).

Its especially useful to see the Last Contact time.
Offline  
Old 01-29-2008, 08:55 AM   #3 (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

Always glad to see other tools to help with reporting. Might be bad timing as the Blackberry Monitoring / Reporting add-on is due with SP5 next month.
Offline  
Old 01-29-2008, 09:05 AM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Looks like it could be useful, seeing as i have the BB Manager open on a laptop to my side most of the day at present. The manager won't run on Vista which i have been lumbered with as a desktop OS, there was a more pressing need for my XP box -
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 01-30-2008, 03:09 PM   #5 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Arrow Here is the application!

moved download to post #1

Last edited by big.phil : 01-31-2008 at 07:22 PM. Reason: version 1.0.0.2 > bug fixes and more columns
Offline  
Old 01-30-2008, 07:27 PM   #6 (permalink)
BMC
New Member
 
Join Date: Jan 2008
Location: Lisbon
Model: 8100
PIN: N/A
Carrier: Optimus
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Awesome!!!
Offline  
Old 01-31-2008, 03:22 AM   #7 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

That is awesome, something i can give to our support team for initial checking. They can see what is happening without fear of changing something and breaking things.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 01-31-2008, 10:29 AM   #8 (permalink)
BMC
New Member
 
Join Date: Jan 2008
Location: Lisbon
Model: 8100
PIN: N/A
Carrier: Optimus
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Big phil,

When i export to csv i get this error and the file is empty:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentException: Argument 'Prompt' cannot be converted to type 'String'.
at Microsoft.VisualBasic.Interaction.MsgBox(Object Prompt, MsgBoxStyle Buttons, Object Title)
at BlackberryReports.FormMain.SFD1_FileOk(Object sender, CancelEventArgs e)
at System.Windows.Forms.FileDialog.OnFileOk(CancelEve ntArgs e)
at System.Windows.Forms.FileDialog.DoFileOk(IntPtr lpOFN)
Offline  
Old 01-31-2008, 11:27 AM   #9 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation fixing the export issue.

hey...thanks for the heads up. i am fixing it right now and will re-post the app when i have it done. it shouldnt take but a few minutes.
Offline  
Old 01-31-2008, 11:55 AM   #10 (permalink)
BMC
New Member
 
Join Date: Jan 2008
Location: Lisbon
Model: 8100
PIN: N/A
Carrier: Optimus
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Since you're hands on the code, can you provide also the Status(running, initializing),Last Contact Time and ServerDN attributes ?
Thanks in advance
Offline  
Old 01-31-2008, 12:53 PM   #11 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

yeah, i will throw them in there. I'm not sure how the BES manager gets its "last contact time" because that column in the database is null. I will look into it.
Offline  
Old 01-31-2008, 01:21 PM   #12 (permalink)
BMC
New Member
 
Join Date: Jan 2008
Location: Lisbon
Model: 8100
PIN: N/A
Carrier: Optimus
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry about my mistake, i also have the same problem. What i'd need is creation and activationtime instead of 'last contact time'

I use this query:


select U.displayname,u.pin,u.creationtime,u.activationtim e,u.mailboxSMTPAddr,i.currentPolicyName,S.ModelNam e,S.PlatformVer,S.AppsVer,S.PhoneNumber,S.IMEI
from userconfig u
LEFT JOIN ITPolicyStatus I ON U.id=i.userconfigid
LEFT JOIN SyncDeviceMgmtSummary S on u.id=S.userconfigid
order by u.displayname
Offline  
Old 01-31-2008, 01:45 PM   #13 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up new version posted

ok, i fixed the export bug and added the other columns.

Last edited by big.phil : 01-31-2008 at 04:36 PM.
Offline  
Old 01-31-2008, 03:08 PM   #14 (permalink)
BMC
New Member
 
Join Date: Jan 2008
Location: Lisbon
Model: 8100
PIN: N/A
Carrier: Optimus
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you getting data from a TSQL querie, if so, try replace int to string with a case statement like this:
Select Status=
Case
when Stat=12 then 'running'
when Stat=10 then 'in cradle'
end,
from
Offline  
Old 01-31-2008, 03:16 PM   #15 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Smile

perfect! i was just talking with my buddy about this and that is what he recommended. i was unsure about the query i will add it now and re-post the new build. thanks for the idea!
Offline  
Old 01-31-2008, 04:26 PM   #16 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up ok, build 1.0.0.2 posted

attached to post #1. added new columns and updated tsql statement to convert several columns to custom strings.

Last edited by big.phil : 01-31-2008 at 07:26 PM.
Offline  
Old 01-31-2008, 10:34 PM   #17 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

nice little app!
Offline  
Old 02-01-2008, 07:14 AM   #18 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Aug 2006
Location: South Africa
Model: 8310i
Carrier: Vodafone
Posts: 202
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Reply

I use MobileMonitor / MobileAnalyzer...worked great for a couple of weeks after an upgrade my data is out of sync...
Offline  
Old 02-01-2008, 11:34 AM   #19 (permalink)
Knows Where the Search Button Is
 
big.phil's Avatar
 
Join Date: Jan 2008
Location: Seattle
Model: Gnex
PIN: varchar
Carrier: VZW (Galaxy Nexus)
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The products from Conceivium look very nice indeed! I have never seen them! Doesnt look free though! This is just meant to be a very lightweight tool.
Offline  
Old 02-01-2008, 01:02 PM   #20 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Feb 2007
Location: Toronto
Model: 9800
Carrier: Rogers
Posts: 319
Post Thanks: 2
Thanked 5 Times in 5 Posts
Default

Quote:
Originally Posted by Raiden View Post
I use MobileMonitor / MobileAnalyzer...worked great for a couple of weeks after an upgrade my data is out of sync...
can you read MDS log file using that tool too ?
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.