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