AFSP:asup-status

#!/bin/ksh # File : upd_asup_status.sh # By : Maarten.deBoer@Atos.net, 2015-08-05 # Subject : Script to update web-file for ASUP status # set -x #(0.2) :With some coloring #(0.3) : Some more coloring #(0.4) : Added ASUP ack DaTi #(0.5) : Added search for COUNTRY in DATABASE #(0.6) : Added file country-asup-data.csv (in stead of TMP) #(0.7) : Mod country #(0.8) : Mode AFSP & ASUP country #(0.9) : Add Legenda #(0.10) : CNT empty DB-country #(0.11) : Mod. ASUP colors #set -x PGM="`basename $0|cut -d\. -f1`" VER="0.11" TMP="/tmp/${PGM}.$$" BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" LOG="${BASEDIR}/log/${PGM}.log" ASUPDATADIR="${BASEDIR}/data/asup" IN="${BASEDIR}/data/asup-data.csv" OUT="${BASEDIR}/html/asup-status.html" OUT="/appl/mdr/www/afsp/asup-status.html" #ASUPACKDIR="/appl/mdr/mdrglob/asup-ack/" ASUPACKDIR="/appl/asup/ack/" COUNTRYAFSP="${BASEDIR}/data/country-afsp-data.csv" COUNTRYASUP="${BASEDIR}/data/country-asup-data.csv" COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`" echo "`date` ${PGM} v${VER} started." | tee -a ${LOG} echo "BASEDIR=${BASEDIR}" # Collect data from all filers and mail rm ${IN} cat ${ASUPDATADIR}/*.csv >> ${TMP} cat ${TMP}|sort >> ${IN} #date|mailx -a ${IN} -s "[${PGM} v${VER}]" maarten.deboer@atos.net echo "" > ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "AFSP:asup-status" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} #echo "

" >> ${OUT} echo " Filer ASUP (by mail/smtp) status of global: " >> ${OUT} echo "
" >> ${OUT} echo " Done by adding mdrglob@msssyscol01.bcklan.ao-srv.com at 'options autosupport.partner.to' " >> ${OUT} echo "

Update: `date`

" >> ${OUT} echo "

" >> ${OUT} echo " For internal use. (c) Atos BTN 2015 " >> ${OUT} echo "

" >> ${OUT} echo "

" >> ${OUT} echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} echo "Collecting of all countries; hostname & ser.nr ..." echo "# COUNTRY;DB_CONTROLER_NAME;DB_SERIAL_NUMBER;DB_SYSTEM_ID;" > ${COUNTRYAFSP} echo "# COUNTRY;DB_CONTROLER_NAME;DB_SERIAL_NUMBER;DB_SYSTEM_ID;" > ${COUNTRYASUP} for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??` do for DBFILE in `ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/*.asc` do DB_SERIAL_NUMBER="`grep ^SERIAL_NUMBER ${DBFILE}|awk -F\= '{print $2}'`" DB_CONTROLER_NAME="`grep ^CONTROLER_NAME ${DBFILE}|awk -F\= '{print $2}'`" DB_SYSTEM_ID="`grep ^SYSTEM_ID ${DBFILE}|awk -F\= '{print $2}'`" echo "${COUNTRY};${DB_CONTROLER_NAME};${DB_SERIAL_NUMBER};${DB_SYSTEM_ID};" >> ${COUNTRYAFSP} done # DBFILE done # COUNTRY EMPTY_DB_CNT=0 cat ${IN}|sort|grep -v ^#|while read LINE do FILER="`echo ${LINE}| awk -F\; '{print $1}'`" LOC="`echo ${LINE}|awk -F\, '{print $2}'|cut -d' ' -f1`" USAGE="`echo ${LINE}|awk -F\, '{print $2}'|cut -d\[ -f2|cut -d\] -f1`" OSVERSION="`echo ${LINE}|awk -F\; '{print $4}'`" FWVERSION="`echo ${LINE}|awk -F\; '{print $5}'|sed 's/ //g'`" SERNR="`echo ${LINE}|awk -F\; '{print $6}'|sed 's/ //g'`" PARTNER="`echo ${LINE}|awk -F\; '{print $7}'|sed 's/ //g'`" SNMPLOC="`echo ${LINE}|awk -F\; '{print $2}'`" SNMPCONTACT="`echo ${LINE}|awk -F\; '{print $8}'|sed 's/ //g'`" LASTASUPDATI="`echo ${LINE}|awk -F\; '{print $9}'`" # ASUP-Ack's # Get the filename of the last Ack FILE="`grep -i hostname ${ASUPACKDIR}/*| grep ${FILER}|cut -d\: -f1|sort|tail -1`" # Get the date&time of the last ack-file ACKFILEDATI="" if [ "${FILE}" != "" ]; then ACKFILEDATI="`stat -c %y ${FILE}|cut -d\. -f1`" fi DATICOL="" YEAR="`date +%Y`" ANSW="`echo "${LASTASUPDATI}"|grep \" ${YEAR}\"`" if [ "${ANSW}" = "" ]; then DATICOL="red" fi ANSW="`echo "${LASTASUPDATI}"|grep \" ${YEAR}\"`" if [ "${ANSW}" != "" ]; then DATICOL="orange" fi MONTH="`date +%b`" ANSW="`echo "${LASTASUPDATI}"|grep \" ${YEAR}\"|grep \" ${MONTH}\"`" if [ "${ANSW}" != "" ]; then DATICOL="yellow" fi DAY="`date +%d`" ANSW="`echo "${LASTASUPDATI}"|grep \" ${YEAR}\"|grep \" ${MONTH}\"|grep \" ${DAY}\"`" if [ "${ANSW}" != "" ]; then DATICOL="green" fi # Get country if [ "${FILER}" != "" ]; then FILERCOUNTRY="`grep ${FILER} ${COUNTRYAFSP}|awk -F\; '{print $1}'|sort -u`" fi # HOSTNAME CTRYCOL="" if [ "${FILERCOUNTRY}" = "" ]; then CTRYCOL="yellow" let "EMPTY_DB_CNT= ${EMPTY_DB_CNT} + 1" else # Country found. So can be witten in ASUP-country file echo "${FILERCOUNTRY};${FILER};DB_SERIAL_NUMBER;DB_SYSTEM_ID;" >> ${COUNTRYASUP} fi echo "${FILER} = ${LASTASUPDATI} = ${ACKFILEDATI} = ${FILERCOUNTRY} ..." echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} done echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} COUNT="`cat ${IN}|grep -v '^#'|wc -l|awk '{print $1}'`" echo " ${COUNT} filer(s) found"|tee -a ${LOG} echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} echo "

" >> ${OUT} echo "

Name:	Serial Number:	Last ASUP DaTi:	ASUP Ack DaTi:	OS Version:	Partner:	SNMP location:	SNMP contact:	AFSP DB Country:
${FILER}	${SERNR}	${LASTASUPDATI}	${ACKFILEDATI}	${OSVERSION}	${PARTNER}	${SNMPLOC}	${SNMPCONTACT}	${FILERCOUNTRY}
Name:	Serial Number:	Last ASUP DaTi:	ASUP Ack DaTi:	OS Version:	Partner:	SNMP location:	SNMP contact:	ASUP DB Country:
${COUNT} filers								${EMPTY_DB_CNT} empty

" >> ${OUT} # Legenda: echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "

Legenda:
Last ASUP:	No information	Not this year	This year	This month	This day
AFSP DB Country:	New to AFSP

" >> ${OUT} # --- footer echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} echo "

" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "Contact: |Content Owner: Maarten de Boer |Last Update: `date`
" >> ${OUT} echo "For internal use (c) Atos S.A. 2015 all rights reserved. Reproduction in whole or in part is prohibited without the written consent of Atos SA." >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "

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