.59c released!

.59c - a "release candidate" has been uploaded to the main site.

Download it here: http://sites.google.com/site/berrystatsadmin/Home/downloads

.59c	Fix	Fixed blank activation password from lite.asp.	2008-11-10
.59c	Addition/Change	When saving settings or using the besuseradminclient page (lite.asp actions), the page will refresh and return to the previous page.	2008-11-10
.59c	Fix	Masked password on lite.asp wasn't working quite right for local roles (not domain logons)	2008-11-10
.59c	Addition/Change	BerryStats will now log besuseradmin client functions, logoff/logon, some errors and report access to the application event log.	2008-11-11

Some issues with .58 - Changing flash charts in .59

I've had some reports that .58 is causing some strange issues with the index page not rendering, and perhaps even an out of memory error or two (it happened on my Vista station at work, but not XP...wha?).

I think it has been isolated to the AMCharts implementation in BerryStats, but I can't be sure. If it is, it is probably because I don't know enough about it to implement it properly.

In any case, I'm dropping it in lieue of Fusion Charts Free - which works out better in terms of licensing, etc.

Fusion Charts free produces some flash based charts that rivals AMCharts in appearance and load times, so it was only a natural selection.

In addition to changing the flash chart provider, I am modifying a few of the charts on the main page - I will make an inclusion for 'top 5 pending carriers' which is a chart showing the top 5 carriers that have pending messages on your devices.

Also, I will include top 5 pending users...

If you have any ideas of other useful charts. Let me know!

At some point, I will be including charts into some of the queries on the custom reporting page.

.58 released

.58	Addition/Change	Added new role "showsqlqueries". When enabled, the SQL query will report at the bottom of the sql.asp page.	2008-09-11
.58	Addition/Change	Pie chart on main page showing users-to-server count.	2008-09-11
.58	Addition/Change	New bar chart on main page will show top 5 users by sent messages.	2008-09-11
.58	Fix	Fixed self-service page so that if a user does not have a BlackBerry, 'Add my BlackBerry' drop-down menu item will appear correctly - (this only occured if a user did not fall into any other role)	2008-09-12
.58	Addition/Change	Added 'disable/enable' self-service option.	2008-09-15
.58	Addition/Change	Added a session.timeout value of 60 minutes within global.asp - will make this user-customizable later.	2008-09-15
.58	Fix	Removed sortable.js references from lite.asp	2008-09-18
.58	Addition/Change	Added image for 9000 series phone (Bold)	2008-09-18
.58	Addition/Change	Added option to delete reports from sql.asp page for admins only.	2008-09-19
.58	Fix	Modified ad search lookup so it will search for *criteria* (with wildcards), making it easier to search for first and last names.

.57 released

New additions include:

57	Addition/Change	Now administrator role can tweak the add user page, hiding/showing BESServer and ITPolicy drop downs from self service users who have the 'add user' function applied to them. Also, Admins can preselect what default server and IT policy will be applied to self-service users.	2008-08-28
.57	Fix	Fixed some issues with 'My BlackBerry' page, where it would automatically redirect to index.asp.	2008-08-28
.57	Addition/Change	Added a new function to sql.asp page which allows you to run a query from an inputbox on the page.	2008-08-28
.57	Addition/Change	Added checkbox on sql.asp which will allow you to select if you wish to output sql results to a single table or to multiple 'pages' within a table.	2008-08-28
.57	Addition/Change	Added 'enable redirection' and 'disable redirection' to user details and roles page	2008-09-02
.57	Addition/Change	Added export function to sql.asp custom reporting page	2008-09-02
.57	Fix	Did some work with roles, i.e. checking them in global.asp, so they are available in all pages. Fixed how some pages were improperly redirecting	2008-09-02
.57	Addition/Change	Made separate views for 4.0.x vs. 4.1.x	2008-09-02
.57	Addition/Change	Added 'message stats for all users' report.	2008-09-02
.57	Fix	Modified besuseradminclient.asp page so that the page expires immediately (so if you hit the 'back' button after submitting a useradminclient command, you will be prompted to cancel submission of the form data).	2008-09-02

Download via the link at the right!

.55 out now, new feature: Selectively enable/disable BESUserAdminClient functions for BerryStats roles...

.55 is out, and the big addition is the new ability to select/deselect BESUserAdminClient functions for your roles.

This means if you only want to grant your helpdesk the ability to reset device passwords and Activation passwords (for example), then you can do so.  You can be as granular as you wish, making it easy to keep people from doing the wrong things in BerryStats!

What you don't see yet but is on my test bed is 'Self Service'...an additional role that allows your users to log in with their AD credentials and perform approved useradminclient functions on their own device (screenshots coming)!

New reports in version .54!

You can now create your own custom reports and make them available in BerryStats, version .54.

I will be working to make it possible to lock these down to unauthorized users, but if you don't have to worry about that, then give .54 a try!

New query page coming soon...

Right now, the queries are pretty limited (only a few to select from), but I am working out a new way of doing this - my intent is to have XML-based reports definitions that allow you to save and run any type of query that you like.

Not only that, but you should be able to trade queries with other users and completely customize your reports within BerryStats.

The page will have a way to define your own SQL query, and also grant you the ability to save and name a query that works for you. Also, I will add a feature to email the results to a SMTP recipient.

Should prove to be fun at the very least...

.53 released

This change should take BerryStats out of beta...

See the changelog on the new BerryStats site...

http://sites.google.com/site/berrystatsadmin/changelog (be sure to sort the version column 'Z-A')

Rob

New home for BerryStats!

I am moving my main page for BerryStats from www.vbshf.com to Google Sites. They have a really cool interface and dynamic way of creating various pages which seems to fit my needs quite well, allowing you to see more of the guts of the project as it progresses, including a more dynamic changelog, feature & enhancement list, and more!

Check it out here:

http://sites.google.com/site/berrystatsadmin/Home

This is where you will find the latest downloads from now on - I will update the link at the right accordingly!

0.52 uploaded: Setup.asp page + some updates!

.52 beta 8/13/08 newness:

• Modified backend XML save/load function, should now update only the elements that changed, rather than delete/saving the file altogether.
• Created 'setup.asp' page for first time installs, no more manual editing of configuration.xml!
• Updated/fixed Domino view to include username and groupname - you must apply this new view!
• Updated Exchange view to include username and groupname - you must apply this new view!
• Updated lite.asp so that it would run the besuseradmin client with Domino username (if username was present). Need people to test this!

.52 beta fixes:

When exporting a spreadsheet to Excel, it opens up as an .asp file instead of .xls - this is because the downloaded file was not being declared as an XLS mime-type menu drop down for licenses would show 1 more license than server status page BB Browser will now redirect to index.asp after a successful logon BlackBerry 8700g was showing no image - this is due to BES or BlackBerry reporting back as only 8700, new image created for 8700_small.jpg Mail server was showing up as 'Exchange' server, now is 'Mail' server

Self Service?

I'm thinking of also including a self-service page for BlackBerry users so they can reset their own activation password (they can set everything else on the device easily enough, I think).

What do you think?

I realize that there is a Web Desktop Manager that RIM is offering, but this requires ActiveX installations on each client that runs it. I figured this would be a bit lighter.

What other functions do you think should be included on a "Self Service" page?

.51beta released!

• Added ‘Export’ function back into ‘BerryStats Classic’ page (under Reporting).
• Modified layout & look of BerryStats Classic (removed iFrame in lieue of DIV)
• Fixed some formatting issues with potentially null values on lite and advanced-query page.
• Added ‘helpdesk’ and ‘reporting’ localized user accounts
• Added some error handling in the logon page

Check the download link at the right to get it!

Issue: LDAP authentication needs a little work...

Not to worry, you should be able to disable LDAP authentication in the meantime if this isn’t working for you.

 

If you are experiencing problems with LDAP and can’t get logged in, enable ‘debug’ in the admin window.  When you try to log in, you should see an LDAP error like this:

 

Error code: -2147217865

Error description: Table does not exist.

 

It appears that I need to add the ability to specify a user account to use when querying the AD structure for proper group membership.  I was wondering if this would come up…

 

I’m working on the code today and tomorrow and hope to have something for you by Tuesday.

Glitch with 0.5 download on 8/6/08: error in config.asp: strAuth

I neglected to include the newest version of the configuration.xml file which included an 'Authentication' node, which causes the above error.

I've since updated the zip download and included the file as an attachment in the main download post as well.

Thanks to Jeremy Knight for finding that for me!

BerryStats 0.5beta ready to go!

Check the link at the right for the download.

The list of updates/changes:

• LDAP authentication for admin/helpdesk users. Also, there is a localized ‘root’ access account for admin purposes.
• Added ‘log out’ functionality
• Added debug option to admin page so you can see what variables are being passed as you work in BerryStats.
• Added original BerryStats report back into page as link under ‘Reports’. This will be enhanced a little so that export to XLS or PDF will be an option.
• Reworked add user page so it can be used via BB Browser.
• Changed some formatting of the lite.asp page so that it is a bit more legible.
• Added phone number format function so phone numbers look like…well, actual phone numbers (xxx) xxx-xxxx
• Changed BB model images to JPG instead of GIF
• Added new BesUserAdminClient functions: send PIN, send Email, view handheld apps, view handheld modules, assign user to group, assign IT policy to user, resend servicebook, resend peer-to-peer key.

BerryStats on Confessions of a freeware junkie

FYI: I posted an entry about BerryStats on my other blog: Confessions of a freeware junkie...take a look... [link] - it presents a nice overview of the features.

LDAP authentication is on its way!

I'm working on the LDAP authentication (which seems to work just fine).

I will have two user groups (maybe three) that will be set up so they can get in and view/modify users on the BES server.


I just now need to add the capability to add/modify the settings for the LDAP authentication to the admin.asp page.

Donate link for BerryStats

For some odd reason, I can't seem to bring in a Paypal donate button into Google sites, so here is a quick donation link for BerryStats - click the image to donate!

Known issues and other notes

Right now, in the beta, there is a pane on the main window that says "Content here"... this is temporary until I figure out what would be the best thing to put here.

This site looks absolutely HORRIBLE, (due to CSS issues I'm sure) in Firefox, and it is mostly because I am NOT a web developer. So, I'm sorry...I will try to work on that for you, but I can't promise anything.

I'm working on some charting and other statistics, but that will take a back seat to:

• AD authentication
• AD lookups for new user additions (finding the email address, for example)
• Reports

More user page goodness...

Additional BES User Admin Client options...

Now you can assign user to a group (page will query existing groups and present them in a drop down chooser) as well as assign an IT policy to a user (pre-populated drop down as well).

And yes, through the BB interface too! I will try to get some screenshots of the BB browser interface. I am still working on some layout idiosyncrasies when it comes to desktop vs. mobile browser.