#!/bin/ksh # File : upd_disk-firmware.sh # By : Maarten.deBoer@Atos.net, 2015-03-14 # Subject : Script to process disk-firmware # set -x #(0.2) : Mod; COUNTRY #(0.3) : Mod; Location -> Model #(0.4) : Mod; Count status #'s -> ksh, Ser.Nr added PGM="`basename $0|cut -d\. -f1`" VER="0.4" TMP="/tmp/${PGM}.$$" #BASEDIR="/appl/mdr/afsp/NL" BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" LOG="${BASEDIR}/log/${PGM}.log" #FLU="${BASEDIR}/etc/filer-location-usage.csv" OUT="${BASEDIR}/html/disk-firmware.html" COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`" #IN="${BASEDIR}/data/firmware/${COUNTRY}-disk-model-firmware-vendor-status.csv" IN="${BASEDIR}/data/firmware/${COUNTRY}-disk-model-firmware-vendor-more.csv" AFSPDB="${BASEDIR}/data/database" echo "`date` ${PGM} v${VER} started. "|tee -a ${LOG} echo "BASEDIR=${BASEDIR}" # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER echo "" > ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "AFSP:disk-firmware" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "
" >> ${OUT} echo " Filer disk-firmware of ${COUNTRY} " >> ${OUT} echo "
" >> ${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 " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} # DISKMODEL;FILER;DISKFW;DISKVENDOR;CNT;PATCHLEVEL1;PATCHLEVEL2;PATCHSTATUS; TTLCNT0=0 TTLCNT1=0 TTLCNT2=0 TTLCNT3=0 cat ${IN}|grep -v ^#|sort -t';' -k 9 -r -k 2|while read LINE do DISKMODEL="`echo ${LINE}|awk -F\; '{print $1}'`" FILER="`echo ${LINE}|awk -F\; '{print $2}'`" DISKFW="`echo ${LINE}|awk -F\; '{print $3}'`" CNT="`echo ${LINE}|awk -F\; '{print $5}'`" PATCHLEVEL1="`echo ${LINE}|awk -F\; '{print $6}'`" PATCHLEVEL2="`echo ${LINE}|awk -F\; '{print $7}'`" STATUS="`echo ${LINE}|awk -F\; '{print $8}'`" STATUSNR="`echo ${LINE}|awk -F\; '{print $9}'`" # LOC="`grep ${FILER} ${FLU} |awk -F\; '{print $2}'|sed 's/ //g'`" # USAGE="`grep ${FILER} ${FLU} |awk -F\; '{print $3}'|sed 's/ //g'`" DBFILE="`grep CONTROLER_NAME=${FILER} ${AFSPDB}/*.asc|cut -d\: -f1`" FILERMODEL="?" if [ -f ${DBFILE} ]; then DB_READ ${DBFILE} FILERMODEL="${DB_MODEL_NAME}" FILERSERNR="${DB_SERIAL_NUMBER}" fi case ${STATUSNR} in 0) let "TTLCNT0= ${TTLCNT0} + ${CNT}"; DISKCOL="green" ;; 1) let "TTLCNT1= ${TTLCNT1} + ${CNT}"; DISKCOL="yellow" ;; 2) let "TTLCNT2= ${TTLCNT2} + ${CNT}"; DISKCOL="orange" ;; 3) let "TTLCNT3= ${TTLCNT3} + ${CNT}"; DISKCOL="red" ;; esac if [ "${STATUS}" = "" ]; then DISKCOL="" fi echo "${DISKMODEL};${FILER};(${FILERSERNR});(${FILERMODEL});${DISKFW};${CNT};${PATCHLEVEL1};${PATCHLEVEL2};${STATUS};${STATUSNR}; ..." # case ${LOC} in # "NL-Eindhoven-HWU") LOCCOL="orange" ;; # "NL-Eindhoven-Hurk") LOCCOL="yellow" ;; # "NL-Eindhoven-Best") LOCCOL="green" ;; # "NL-Amsterdam-NRW") LOCCOL="lightblue" ;; # *) LOCCOL="grey";; # esac echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "" >> ${OUT} done # cat ${IN} # Last row echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "
Filer: Serial Number: Model: Diskmodel: (curr.)Firmware: Count: Patchlevel NetApp (to be): Patchlevel IBM (to be): Status:
${FILER} ${FILERSERNR} ${FILERMODEL} ${DISKMODEL} ${DISKFW} ${CNT} ${PATCHLEVEL1} ${PATCHLEVEL2} ${STATUS}
Filer: Serial Number: Model: Diskmodel: (curr.)Firmware: Count: Patchlevel NetApp (to be): Patchlevel IBM (to be): Status:
" >> ${OUT} # Calculate % TOTALTTL=${TTLCNT0} let "TOTALTTL= ${TOTALTTL} + ${TTLCNT1}" let "TOTALTTL= ${TOTALTTL} + ${TTLCNT2}" let "TOTALTTL= ${TOTALTTL} + ${TTLCNT3}" let "PERCCNT0= ${TTLCNT0} * 100 / ${TOTALTTL}" let "PERCCNT1= ${TTLCNT1} * 100 / ${TOTALTTL}" let "PERCCNT2= ${TTLCNT2} * 100 / ${TOTALTTL}" let "PERCCNT3= ${TTLCNT3} * 100 / ${TOTALTTL}" # 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 " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo "
Legenda:
Status: Patchlevel OK No (NetApp- / IBM-) patchlevel Patchlevel less (-1) then OK Patchlevel to (-2) low
Disks: ${TTLCNT0} = ${PERCCNT0} % ${TTLCNT1} = ${PERCCNT1} % ${TTLCNT2} = ${PERCCNT2} % ${TTLCNT3} = ${PERCCNT3} % ${TOTALTTL} = 100 %
Remarks: The amount of disks may be devided by 2
(in case of HA-pairs).		 The percentage (%) is correct.
" >> ${OUT} echo "

" >> ${OUT} #echo "" >> ${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} echo "`date` ${PGM} finished. "|tee -a ${LOG} exit 0