[SOLVED] daily zwc access report via mail

[gregor]

hi,

how can i get zimbra to send a daily zimbra webclient access report via mail. i need informations about who access the zwc from which ip and when.
how can i do this?

is use the open source edition (Release 5.0.9_GA_2533.RHEL5_20080815132719 CentOS5 FOSS edition)

greetings from austria
gregor

[rchinn]

Access to the web client, IMAP, POP3, etc is logged in /opt/zimbra/log/mailbox.log. You could write a script to parse it every day to see who's active and from where.

[rchinn]

I wrote a simple script that parses yesterday's log file for ZWC access and prints a comma-separated list of users and IP addresses:

#!/bin/bash

PATH="/usr/bin:/bin"

# Find yesterday's log file
logfile=`ls -1 /opt/zimbra/log/mailbox.log.*|sort | tail -n 1`

# Find NoOpRequest entries in the log and output as comma-separated list
cat $logfile | grep "ZimbraWebClient" | grep "name=" | grep "NoOpRequest" | cut -d " " -f 6 | tr ";" " " |tr "=" " " | cut -d " " -f 2,6 | sort | uniq | tr " " ","

There are probably more elegant ways to do it, but this seems to work. You could call this from your crontab any time after midnight when the log file is rotated.

[gregor]

hi,

thank you for the help, it works :-)

gregor