Re: [Mailman-Users] Mailman stat's

[Larry Hansford]

At 09:08 PM 2/5/2003, you wrote:

Here is a stat's script that we use.  It sends out monthly status
reports to the Mailman admins as well as to each lists admin.

#For the number of lists:
 ~mailman/bin/list_lists -b |wc -l

#For the number of users in each list:
  for i in `~mailman/bin/list_lists -b`;
  do
    j=`~mailman/bin/list_members $i |wc -l`
    echo "list $i has $j members"
  done


=== mm_stats script ===
#! /bin/bash
# Run monthly stats on Meeting maker logs
#  - top 10 users of each list
#  - Number of attempted posts (per list)
#  - Total bytes sent (per list)
#
# Mailman's log file to be examined for stats
# We rotate the logs monthly and run this script
# around 6am on the first of each month.
# The newly rotated monthly file is post.1
POST=~mailman/logs/post.1

# create temp file to collect stats
TMPFILE=`mktemp /tmp/mm_stats.XXXXXX` || exit 1

LIST="`/home/mailman/bin/list_lists |awk '{print $1}' |sed -n '2,$p'`"
for i in $LIST
do
  echo "Stats from local Mailman list: $i" > $TMPFILE
  echo " "  >> $TMPFILE
  echo -n "   Starting:  " >> $TMPFILE
  head -1 $POST |cut -f1-3 "-d " >> $TMPFILE
  echo -n "   Ending:    " >> $TMPFILE
  tail -1 $POST |cut -f1-3 "-d " >> $TMPFILE
  echo " ===" >> $TMPFILE
  echo -n "Total posts to the list: " >> $TMPFILE
  grep -i "post to $i " $POST |wc -l >> $TMPFILE
  echo -n "Total SUCCESSFUL posts to the list: " >> $TMPFILE
  grep -i "post to $i " $POST |grep success |wc -l >> $TMPFILE
  SIZ=`grep -i "post to $i" $POST |grep success \
      |cut -f2 -d= |cut -f1 -d,`
  k=0; for j in $SIZ; do k=$(( j + k )); done
  echo "  Total bytes" = $k >> $TMPFILE
  echo " "  >> $TMPFILE
  echo "Top 10 posters to the list:" >> $TMPFILE
  grep -i "post to $i " $POST |cut -f 10 "-d " |sort |uniq -c \
     |sort -bgr |head -10 >> $TMPFILE
  echo " " >> $TMPFILE
  # Mail collected stats off to the list admin and cc the mailman user
  mail -s "Mailman Stats for List: $i" -c mailman $i-admin <$TMPFILE
done

# remove the temp file
rm $TMPFILE
=== end of mm_stats script ===

Hope these help - Jon Carnes

Thanks for the script, Joh! Looks great.

I've trying to develop a script to run the "bin/list_members --nomail" for each mailing list once a month, with the results mailed to the list administrator. Does anyone have an easy way to accomplish that? The reason I want to generate those reports is to allow the list owners to see which members have been set to nomail due to bounces and need attention.

Again, thanks!

Larry




------------------------------------------------------
Mailman-Users mailing list
[EMAIL PROTECTED]
http://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/

This message was sent to: archive@jab.org
Unsubscribe or change your options at
http://mail.python.org/mailman/options/mailman-users/archive%40jab.org