compare-list

#!/bin/ksh # File : upd_compare-list.sh # By : Maarten.deBoer@Atos.net, 2015-09-14 # Subject : Script to update web-file for compare-list status #(0.2) : Added country ($1) to it #(0.3) : Added comments.csv, REMARKS, CSV, MAILTO #(0.4) : Mod. colors #(0.5) : 2014 <-> 2015 #(0.6) : Mod for 2016 #set -x PGM="`basename $0|cut -d\. -f1`" VER="0.6" TMP="/tmp/${PGM}.$$" BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" LOG="${BASEDIR}/log/${PGM}.log" ASUPDATADIR="${BASEDIR}/data/asup" IN="${BASEDIR}/data/compare-filer-list.csv" IN="/appl/mdr/mdrglob/afsp/glob/data/compare-filer-list.csv" OUT="/appl/mdr/www/afsp/compare-list.html" COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`" COMMENTFILE="${BASEDIR}/data/comments.csv" CSV="${BASEDIR}/data/${COUNTRY}-compare-list.csv" MAILTO="maarten.deboer@atos.net" echo "`date` ${PGM} v${VER} started." | tee -a ${LOG} echo "BASEDIR=${BASEDIR}" touch ${TMP} if [ "${COUNTRY}" = "glob" ]; then # OUT="/appl/mdr/www/afsp/${COUNTRY}/compare-list.html" if [ "${1}" != "" ]; then COUNTRYFILTER="${1}" OUT="/appl/mdr/www/afsp/${COUNTRYFILTER}/compare-list.html" CSV="${BASEDIR}/data/${COUNTRYFILTER}-compare-list.csv" fi else COUNTRYFILTER="${COUNTRY}" OUT="/appl/mdr/www/afsp/${COUNTRY}/compare-list.html" fi echo " Countryfilter=${COUNTRYFILTER}"|tee ${LOG} echo " OUT=${OUT}"|tee ${LOG} echo "" > ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " compare-list " >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} #echo "

" >> ${OUT} echo " Filer compare list of ${COUNTRY} " >> ${OUT} echo "

" >> ${OUT} echo " For internal use. (c) Atos 2016 " >> ${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 "# Serial Number:;Name:;Country at Atos:;ASUPs found:;Country of NetApp list of 2016:;Comments:;AFSP remarks:;" > ${CSV} cat ${IN}|sort|grep -v ^#|while read LINE do SERNR="`echo ${LINE}|awk -F\; '{print $1}'|sed 's/ //g'`" FILER="`echo ${LINE}| awk -F\; '{print $2}'`" ATOSCOUNTRY="`echo ${LINE}| awk -F\; '{print $5}'`" ASUPFOUND="`echo ${LINE}| awk -F\; '{print $6}'`" NETAPP1COUNTRY="`echo ${LINE}| awk -F\; '{print $8}'`" # NETAPP2COUNTRY="`echo ${LINE}| awk -F\; '{print $6}'`" NETAPP2COUNTRY="" if [ "${ATOSCOUNTRY}" = "${COUNTRY}" ]; then COUNTRYCOL="green" else COUNTRYCOL="" fi if [ "${ASUPFOUND}" != "" ]; then ASUPCOL="green" else ASUPCOL="" fi if [ "${NETAPP1COUNTRY}" = "${COUNTRY}" ]; then NETAPP1COUNTRYCOL="green" else NETAPP1COUNTRYCOL="" fi if [ "${NETAPP2COUNTRY}" = "${COUNTRY}" ]; then NETAPP2COUNTRYCOL="green" else NETAPP2COUNTRYCOL="" fi if [ -f ${COMMENTFILE} ]; then COMMENTS="`grep ${SERNR} ${COMMENTFILE}|grep -v ^#|grep ${FILER}|awk -F\; '{print $3}'`" case "${COMMENTS}" in "Unknown") COMMENTCOL="yellow" ;; "Active") COMMENTCOL="green" ;; "Decommissioned") COMMENTCOL="blue" ;; *) COMMENTCOL="" ;; esac fi # comments REMARKS="" REMARKSCOL="" FILERCOL="" if [ "${COMMENTS}" != "" ]; then FILERCOL="yellow" REMARKS="See comments." REMARKSCOL="yellow" fi if [ "${ASUPFOUND}" = "" ]; then FILERCOL="orange" REMARKS="No ASUP found." REMARKSCOL="orange" fi if [ "${ATOSCOUNTRY}" = "${COUNTRY}" ] && [ "${ASUPFOUND}" != "" ]; then FILERCOL="" REMARKS="" REMARKSCOL="" fi if [ "${ATOSCOUNTRY}" = "${COUNTRY}" ] && [ "${ASUPFOUND}" != "" ] && [ "${COMMENTS}" = "Active" ]; then FILERCOL="green" REMARKS="" REMARKSCOL="" fi if [ "${COMMENTS}" = "Unknown" ]; then FILERCOL="yellow" REMARKS="To be sorted out why unknown." REMARKSCOL="yellow" fi if [ "${COMMENTS}" = "Decommissioned" ]; then FILERCOL="blue" REMARKS="Remove from lists." REMARKSCOL="orange" fi TTLCNT=0 if [ "${ATOSCOUNTRY}" = "${COUNTRYFILTER}" ] || [ "${NETAPP1COUNTRY}" = "${COUNTRYFILTER}" ] || [ "${NETAPP2COUNTRY}" = "${COUNTRYFILTER}" ]; then echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} # echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} let "TTLCNT= ${TTLCNT} +1" echo "${SERNR};${FILER};${ATOSCOUNTRY};${ASUPFOUND};${NETAPP2COUNTRY};${NETAPP1COUNTRY};${COMMENTS};${REMARKS};"|tee -a ${CSV} fi done 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 " ${TTLCNT} filer(s) found"|tee -a ${LOG} #echo "" >> ${OUT} # echo " " >> ${OUT} #echo "" >> ${OUT} echo "

" >> ${OUT} echo "

Serial Number:	Name:	Country at Atos:	ASUPs found:	Country of NetApp list of 2016:	Country of NetApp list of decom 2016:	Comments (comments.csv):	AFSP remarks:
${SERNR}	${FILER}	${ATOSCOUNTRY}	${ASUPFOUND}	${NETAPP2COUNTRY}	${NETAPP1COUNTRY}	${COMMENTS}	${REMARKS}
Serial Number:	Name:	Country at Atos:	ASUPs found:	Country of NetApp list of 2016:	Comments (comments.csv):	AFSP remarks:
${TTLCNT} filers

" >> ${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 "

Legenda:
Filer name:	Action to be taken	See comments	Is OK	Decommissioned

" >> ${OUT} 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} # Mail CSV-file date | mailx -a ${CSV} -s "AFSP ${COUNTRY} compare list [${PGM} v${VER}]" ${MAILTO} echo " Mailed to ${MAILTO}"|tee -a ${LOG} rm ${TMP} echo "`date` ${PGM} finished." | tee -a ${LOG} exit 0