FAST! "Executed in 0.657736063004 seconds" And that's with the new added columns.

The only problem I have now (and blubyu knows about it) is I get this at the top of the page:
"Notice: Constant PAGETITLE already defined in c:\inetpub\wwwroot\berrystats\stats\includes\confi g.php on line 2

Notice: Constant COMPANY already defined in c:\inetpub\wwwroot\berrystats\stats\includes\confi g.php on line 3"

No more errors!
Changed the error handling in the PHP.INI file to:
error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR

And no more notifications! Thanks blubyu!!

Glad you got the notices taken care of Have you tried the blue theme yet? If you edit the html_header.php file and change default.css to blue.css you will get a different colored theme. It was donated by a member of this forum.

I worked a little bit on the find user/handheld last night. It works but I need to clean it up a bit before it is ready for people to try.

i've got some images for the find/search tool ... heh. its just a magnifying glass, but i'll send it over to you later on today.

Yeah, I'm using the blue theme, I like that. Let me know if you want me to test out the find user option. By the way, now that I'm in the office and not running the page remotely, I'm getting the following speeds on 221 users:
Executed in 0.0378608703613 seconds

Pretty d*** quick!

cayzac - I just finished up the search stuff. I think it works pretty well. I will send you the zip file with the new code. You should be able to search on any part of the users name or the PIN number of the handheld. I need to type up a small ReadMe file becuase I have made a couple of other changes

send me the new files too

Fix these by changing the function include to include_once in both serverinfo.php and serverstats.php.

blubyu, check that and make sure its correct. I was receiving the same errors as cayzac, so I changed the above functions and its now working correctly with no errors.

What I just did here was to comment out the line from both serverinfo.php and serverstats.php. We really shouldn't need that line. The config.php is already being loaded by the index.php. Give it a try on your end and let me know what happens.

Did anyone refine the asp pages that is willing to share them?

Thanks!

define refine. It serves my purposes, so I haven't done any more development on it. I am working on this stuff tonight to help someone get it setup. Let me know what changes you want and I will mod the asp and repost.

Bjgrim - You are alive

The earth is round... Who knew?... Sorry all. I have been way too busy as of late. I have been reading only.

blubyu, guess who still hasn't heard back from the PECL group? hehe.

I'm upgrading my server to 2003 tomorrow, so I'll have a new, fresh installation of PHP and BES, so I'll test it out on there, as well.

jibi - and I see you are still alive also I have been working on other things lately. I was working on the other ssh method but I got busy doing other things and haven't picked it back up. Let me know how the install goes. If you still can't get the PECL stuff working then I will pick back up my efforts on the other ssh method. The code to add/remove will work fine, it is just the ssh connection I need to get working again.

Great tool, thanks.

I am not able to get all the phone numbers, device types, IMEI numbers (only some show up). Any ideas what is wrong? I am on 4.0SP2 with E2K3 on W2K3 server. Using SQL for dbase.

Thanks!

Typically, this is because the device is not running 4.0. The handhelds did not start "inventory" until 4.0.

I talked with one of our folks here today about the leading zeros sorting issue in the inactive field of the view. He gave me an entirely new way to look at it. after it is converted to a string, add more zeros than you need and then do a right function to grab the part you want. I could have smacked myself for it being so simple. I have updated the view and will update the zip file tonight, but I thought I should share the discovery.

RIGHT('000' + RTRIM(CONVERT(nchar(10), DATEDIFF(hh, dbo.UserStats.LastFwdTime, GETUTCDATE()) / 24)), 3)
+ ' Days ' + RIGHT('00' + RTRIM(CONVERT(nchar(10), DATEDIFF(mi, dbo.UserStats.LastFwdTime, GETUTCDATE()) / 60 - DATEDIFF(hh,
dbo.UserStats.LastFwdTime, GETUTCDATE()) / 24 * 24)), 2) + ' Hrs' AS Inactive

Possibly making the Page a little smaller. I also Have an issue with My Domino ServerDN's (Name) not showing. The last Update Time's are all the same and the inactive times are always the same.

This may be normal Im not sure.

Thanks for any Help!

Not dealt with Domino yet. We run exchange. Email me some contact info at and we can chat about it tonight or tomorrow. berry IM, ICQ, yahoo, AIM, or just berry pin. I'm not picky. After we figure it out, we can post back here.

There are some slight differences in the differnet database schemas. I run GroupWise here. When I was making the php pages everything worked fine. When jibi tried them out on his exchange system we noticed that some of his fields didn't show up. We compared and saw that some field names are different. Shouldn't be too hard to track them down though.

Thanks BJGrim - I forgot that little piece of the puzzle.