Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect » kmsreport.pl
  •  
jshaw541

Messages: 471
Karma: 0
Send a private message to this user
Hi all,

I've finally gotten around to release a Perl script that I've been using in-house for almost a year now. It's called kmsreport and generates a large amount of statistics by parsing your KMS log files.

Although its easy to setup, you want to be comfortable with Perl, at this point. It's currently very beta, as I've only tested it with our KMS server, but it runs very well. Feedback and suggestions welcomed. I know the few people who have seen it so far have suggested graphical graphs, and I may take a look at that some point.

More information, downloads, and example output here:
http://people.sps.lane.edu/jshaw/kms/

Kerio MailServer 6.7.1 w/AD
Windows Server 2003 SP 1
Dell PowerEdge 2850 (Dual Xeon 3.2ghz and 2 GB RAM)
~1300 users
~1000+ concurrent IMAPS connections
iPhone users
Outlook 2007 KOFF users
Apple iCal 10.5/10.6 users
  •  
Ctrl+Alt+Del

Messages: 10
Karma: 0
Send a private message to this user
very nice work, too bad the link is down :/
  •  
jshaw541

Messages: 471
Karma: 0
Send a private message to this user
Which link are you having problems getting to? The one I pasted, or one on the webpage? We've been having some network glitches today.

Kerio MailServer 6.7.1 w/AD
Windows Server 2003 SP 1
Dell PowerEdge 2850 (Dual Xeon 3.2ghz and 2 GB RAM)
~1300 users
~1000+ concurrent IMAPS connections
iPhone users
Outlook 2007 KOFF users
Apple iCal 10.5/10.6 users
  •  
Ctrl+Alt+Del

Messages: 10
Karma: 0
Send a private message to this user
the example output link, but now it does work :)

gonna play a little with that nifty pl of yours when i get the time :)
  •  
ChrisL

Messages: 4
Karma: 0
Send a private message to this user

Roughly how big are your log files, and how long does the script take to execute?

Thanks
  •  
jshaw541

Messages: 471
Karma: 0
Send a private message to this user
I just trimmed my log files down, but I was at several hundred megs for my mail.log file, and a hundred or two megs for my other logs. the script was able to process them in a little over 2 minutes as I recall, on our dual 2.8ghz Xeon mail server with 2GB ram.

I spent quite an amount of time benchmarking and optimizing the script for speed and memory usage.

Kerio MailServer 6.7.1 w/AD
Windows Server 2003 SP 1
Dell PowerEdge 2850 (Dual Xeon 3.2ghz and 2 GB RAM)
~1300 users
~1000+ concurrent IMAPS connections
iPhone users
Outlook 2007 KOFF users
Apple iCal 10.5/10.6 users
  •  
ChrisL

Messages: 4
Karma: 0
Send a private message to this user
Reason I ask is that I am doing a similar thing in asp.net I am using a component called chart director, and find it absolutely superb for drawing graphs and charts. There is a version for perl, not sure if you are interested but thought I would mention it as a graph speaks a thousand numbers :)

http://www.advsofteng.com/gallery_bar.html

  •  
yacine

Messages: 17

Karma: 0
Send a private message to this user
Hi,

Thank you for this script, this is the kind of information I was looking for. Thanks again so then I do not need to start from scratch ;-)

BTW for those how would to run it on Unix :

First, do a dos2unix kmsreportdev.pl to remove all the windows chars (like ^M). If you don't you will certainly have this error msg : bad interpreter: No such file or directory

Next, change the two lines below :
# Windows path :
#$seclogfile = $keriodir . "\\" . $seclogfile;
#$maillogfile = $keriodir . "\\" . $maillogfile;
# Unix path :
$seclogfile = $keriodir . "\/" . $seclogfile;
$maillogfile = $keriodir . "\/" . $maillogfile;

Last, do the regular changes (perl path, logs path, ...) and
launch it.

Tested on Linux RedHat 9, KMS 5.7.6

Regards,
Yacine.
  •  
jshaw541

Messages: 471
Karma: 0
Send a private message to this user
Hrm, I need to fire my quality control dept :)

I'll get these items fixed, shortly.

Kerio MailServer 6.7.1 w/AD
Windows Server 2003 SP 1
Dell PowerEdge 2850 (Dual Xeon 3.2ghz and 2 GB RAM)
~1300 users
~1000+ concurrent IMAPS connections
iPhone users
Outlook 2007 KOFF users
Apple iCal 10.5/10.6 users
  •  
sirjosi

Messages: 71
Karma: 0
Send a private message to this user
are you using this then to generate your kms log reports?

pay it forward
-sirjosi
Previous Topic: receiving problem!!!
Next Topic: remove kerio from fotter on list messages
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Sat Nov 18 05:30:09 CET 2017

Total time taken to generate the page: 0.00430 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.