Thanks for checking QC-
Grimlin helped me for a few hours yesterday to get it going. It's up and running now, I owe him.
Great work guys, thanks for everyones help.

What was the issue? Just so we can have it here for anyone else who might be having the same issue.

Definitely interested. I work on this stuff in spurts though, so past performance is not indicative of future returns...

It wasn't anything to do with his berrystats config. He zipped up the dir and sent it to me. I put it on my test box and it ran without any modifications. There was something wrong with his IIS install. My best guess is that he was either missing(or had a corrupted install of) the ASP engine or the XML parser. He ended up moving it to another box and running it from there.

Hello.

You've done an excelent job with the BBstats. I realy appreciate it but I am not able to get it to work. I installed it on a server (hostname> ServerPHP , IP> 10.233.97.196) with apache2 and php4 running. Everything is good so far. The BES 4.1 is installed on ServerBES , IP 10.233.97.203. On the same server is installed MS SQL 2000 SP4 , IIS, BB router. The MS-SQL username is "adminsql" and password "password".

So my question is, what parameters and how should I change them in index.php and user.php to make bbstats work? (I cant see there any config.php, is there any new ver. of BBstats?)

Should I give you another information to solve my problem??

THX for everything

This is the thread for ASP BerryStats, so you might not get a lot of helpful information here...it appears you want to run the PHP version, soooooo...here's the proper thread:
http://www.blackberryforums.com/bes-...errystats.html

Best regards,
Rob

QC, I wanna ask U one thing. I just realised, that your ASP version of BBstats includes also a "Add User" option. I would like to implement it also to phpberrystats, because I miss it there somehow

Im not so good in writing selects and inserts. So could you please provide me the correct selects and inserts to add this feature to PHPberry as well? It would be so helpful. Or if you do like PHP and have a little time, could you write me an instance of the Add User PHP script?

THANXX

DVX - I'm not good with the PHP (if at all), but this is actually a feature of the BesUserAdminClient tool from the BES Resource kit. If you can get someone to write a PHP front-end to that, you'd be golden.

Basically you just have a form that asks for a few options like activation password timeout, user email address, a quick SQL statement that queries for Policy names (from the ITPolicy table), then populates a drop-down, then it runs the besuseradmin client tool to add the user. At the tail-end of the process, the form sends an activation email to your specified user.

Or, you could wait a little bit, I should have an updated ASP beta coming out within the next 7 days. I'm working on making the besuseradmin actions work over a BlackBerry browser - just haven't had time this last week.

OK, but the Add User function is already in your 0.31 beta. So how did you manage to implement that function to the ASP code? You've used the BES Admin tool, or how? Isn't it just some SQL Insert queries to the MS SQL database (BESMgmt) which could be performed via a script language like ASP or PHP?

No - it's a very basic front-end that only queries for the ITPolicies and populates them into a drop-down so you can pick them when you add the user.

Otherwise, all other entries into the form are manual, and it passes whatever you've entered into command-line options to the besuseradmin client, which runs on the web server - I hope that helps.

can you please provide me a link to the correct version of the besuseradmin client that you are using? we have a BES 4.1

I found at https://www.blackberry.com/Downloads/browseSoftware.do an application called "BlackBerry User Administration Tool v4.1.4". It is a ZIP file, which contains a number of DLLs, tvo EXEs and one PDF. It is configured in a command line by typing "besuseradminservice -install exchange" and answering some questions. So you mean, that it is possible to run the besuseradminservice and after that to write a PHP script which would use the commands e.g. "besuseradminclient -add -p password1.." ?

That sounds not bad if it is functioning.

I installed it on a different PC than the BES4.1 fo Exchange is installed. The BES installation was performed on a domain user name domain1\besuser and the BESuserAdmin installation on a domain user name domain1\userA. The MAPI profile is BESMAPI. I cant get them to work. There are two errors in the event viewer
- MAPILogonEx() failed (80040111) for profile: BESMAPI
- Failed to initialize MAPI session.

Do you have any clue how to solve it? Without the besuseradmin service, I cant start the Client...

THX 4 every help!

It looks like the sql view in berrystats will not poll the entire exchange server name from the serverDN dir. In 2007 Microsoft has changed this field spacing in the DN. So the string is longer in 2007 then 2003. The string in 2007 and 2003 I have pasted below....
================================================== =====
/o=Cargill/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Configuration/cn=Servers/cn="My 2007 Exchange Server Name"/cn=Microsoft Private MDB
================================================== ======
/o=Cargill/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=="My 2007 Exchange Server Name"/cn=Microsoft Private MDB
================================================== =====

In the SQL view it polls the server name by using
SUBSTRING(CAST(dbo.UserConfig.ServerDN AS varchar(100)), PATINDEX('%Servers/cn=%',
dbo.UserConfig.ServerDN) + 11, PATINDEX('%/cn=Microsoft%', dbo.UserConfig.ServerDN) - (PATINDEX('%Servers/cn=%', dbo.UserConfig.ServerDN)
+ 11)) AS ExchServer

Going forward with exchange 2007 you will not be able to use this because the spacing is different on the server DN.
Berrystats only polls the first 7 digits and does not give you the entire exchange server name for that field.

If anyone has worked on this please let me know.

I've tried to install ASP berrystats, but having some issues. When i tried to load admin.asp i just see "BerryStats (ASP) configuration with a blue background around it and a submit button, nothing else. When i click submit, it says configuration saved.

I tried to go right to server/berrystats and after some tweaking of the different files I was able to get it to show up... Can anyone help as to why i can't see admin.asp correctly?

Awesome little app, wish I stumbled across this earlier!

We are evaluating a bit of software called Zenprise and it really is phenominal at pushing out "management friendly" reporting/statistics... heck it could help a salesman flog ice to an eskimo. Not to mention the amount of pro-active troubleshooting it does in an ITIL kind of way.

Zenprise is a good product that gets better with each new version. Great support too...

don't forget pricey... I would have loved to have brought it into a number of environments, but found it to be price prohibitive, especially without and enterprise licence...

I have a problem, seems that after we installed all the maintenance release for 4.1.4........berrystats quit working. All I get now is "No data was found that matches this criteria." No drop down menus show up for DisplayName or PIN, but they do for Status, ModelName and Inactive. Any ideas? Worked awesome for a long time and now, nothing. If I click on the Status and change it to Running, then I can see all the DisplayNames......that's the only way.

Did you take a look at the alternative products - BoxTone Enterprise-class BlackBerry User-Level Monitoring & Management and www.bnator.com - Home

FYI, some updates:

BerryStats and Useful tools for BlackBerry Administrators