#!/bin/ksh
# File	: rpt_filer_customer.sh
# By	: Maarten.deBoer@Atso.net, 141121
# Subject	: Report active (running vfiler) customers /filer
#(0.2)	: Added filer /custs
#(0.3)	: Mod for customers-nadt.csv
#set -x
PGM="`basename $0|cut -d\. -f1`"
VER="0.3"
TMP="/tmp/${PGM}.$$"
CSV="/tmp/${PGM}.csv"
SSH="/usr/bin/ssh -n"

HOSTNAME="`hostname|cut -d\. -f1`"
FILERS="${HOME}/etc/filers"
MAILTO="maarten.deboer@atos.net"
#MAILTO="fsod@atos.net"
LOG="${HOME}/log/${PGM}.log"
#CUSTS="${HOME}/etc/customers"
CUSTS="${HOME}/etc/customers-nadt.csv"
FILERSLOCSTYPES="${HOME}/etc/filers-locs-types"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
touch ${TMP}

for FILER in `cat ${FILERS}|grep -v ^#`
do
  echo "${FILER} ..."
  ${SSH} ${FILER} vfiler status|grep running|grep -v vfiler0|awk '{print $1}'|sed 's/nlnafv//g'|sed 's/[0-9]//g'|sort -u|while read CUST REST
  do
    CUSTOMER="`grep \"${CUST};\" ${CUSTS}|awk -F\; '{print $1}'`"
    FILERTYPE="`grep ${FILER} ${FILERSLOCSTYPES}|awk -F\; '{print $3}'`"
    echo "${FILER};${FILERTYPE};${CUST};${CUSTOMER};"|tee -a ${TMP}
  done  # while

done # for

echo "# Filer;Type;Customer-Code;Customer-name;" > ${CSV}
cat ${TMP} >> ${CSV}
echo "#" >>  ${CSV}
echo "# ${PGM} v${VER} @${HOSTNAME} at `date`" >>  ${CSV}
date|mailx -a ${CSV} -s "Active customers per filer report [${PGM} v${VER}]" ${MAILTO}

cp /dev/null ${TMP}
cat ${CSV}|grep -v ^#|awk -F\; '{print $3,$4}'|sort -u|while read CUST REST
do
  echo "${CUST};${REST}" |tee -a ${TMP}
  grep "${CUST};" ${CSV}|awk -F\; '{print ";;"$1";"$2";"}'|tee -a ${TMP}
done  # cat
echo "# Customer-Code;Customer-name;Filer;Type" > ${CSV}
cat ${TMP} >> ${CSV}
echo "#" >>  ${CSV}
echo "# ${PGM} v${VER} @${HOSTNAME} at `date`" >>  ${CSV}
date|mailx -a ${CSV} -s "Filers per active customer report [${PGM} v${VER}]" ${MAILTO}


rm ${TMP} ${CSV}
echo "`date` ${PGM} finished."|tee -a ${LOG}
exit 0