#!/bin/ksh # File : upd_models.sh # By : Maarten.deBoer@Atos.net, 2015-03-14 # Subject : Script to process filer-release input to web-pages #(0.3) : Mod FONT #(0.4) : Add COntact #(0.5) : Mod dir's & added LOG #(0.6) : Added BASEDIR, Mod: html/versions.html #(0.7) : From proc_versions.sh #(0.2) : Add COUNTRY #(0.3) : Mod IN-file #(0.4) : Update modelcolors #(0.5) : Mod. When no SerNR no usage, Model change SerNr #(0.6) : If FILER="", the FILER="", USAGE -> LAST_ASUP. No BIOS versions #(0.7) : Added asup-ack #(0.8) : Some mod.s #(0.9) : Mod is no MODEL #(0.10) : Added if [ "${EOSYEAR}" != "" ]; then #(0.11) : Add Overall status of last ASUP. FOr beeing used at upd_dashboard. Added DASHBOARDFILE,DASHBOARDASUPCOL #(0.12) : Remove "Ack DaTi:", Rem ${LOC} #(0.13) : Mod. ASUP colors #(0.14),160725 : Add DFM-server & Last DFM-update & DB_READ #(0.15),160726 : Added REMARS & REMCOL & Removed (#-ed) ACK #(0.16),170419 : Added DASHBOARDASUPCOL at botom/Legenda: #(0.17),170508 : Upd OSCOL #(0.18),170509 : Upd OSCOL #(0.19),170828 : Removed DFM-servername: Last DFM update: #(0.20),170830 : Added create $LOGdir #(0.21),170830 : Removed FLU, OUT -> HTML, Changed getting info from IN-file -> AFSP-DB (sorted bu SerNr & 1st col = Ser.Nr) #(0.22),170907 : Added EMPTY_ASUP_CNT #(0.23),171207 : Some mod's. Add FILECNT #(0.24),180508 : Added EOS HW & EPOCH #(0.25),180508 : Added Agreed SW rel #(0.26),180524 : Added (ASUP) date check for UTC. Should not be in most of the countries. => BLUE + MAILTO #(0.27),180528 : Changed Last ASUP more to the front #(0.28),180530 : Mod; tee -a ${DASHBOARDFILE} # set -x PGM="`basename $0|cut -d\. -f1`" VER="0.28" TMP="/tmp/${PGM}.$$" MAILTO="maarten.deboer@atos.net" EPOCH_YR=31536000 BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" if [ ! -d ${BASEDIR}/log} ]; then mkdir -p ${BASEDIR}/log fi LOG="${BASEDIR}/log/${PGM}.log" EMPTY_ASUP_CNT=0 FILECNT=0 IN="${BASEDIR}/data/model-version/filer-name-loc-model-os-fw-sn-partner.csv" HTML="${BASEDIR}/html/models.html" COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`" AFSPDBDIR="${BASEDIR}/data/database" DASHBOARDFILE="/appl/mdr/mdrglob/afsp/${COUNTRY}/data/dashboard.asc" touch ${DASHBOARDFILE} echo "BASEDIR=${BASEDIR}" echo "AFSPDBDIR=${AFSPDBDIR}" echo "DASHBOARDFILE=${DASHBOARDFILE}" # Filer End Of Support FILEREOS="/appl/mdr/mdrglob/afsp/glob/etc/filer-end-of-hw-support.csv" FILEREOSSW="/appl/mdr/mdrglob/afsp/glob/etc/filer-end-of-sw-support.csv" echo "`date` ${PGM} v${VER} started." | tee -a ${LOG} echo "BASEDIR=${BASEDIR}" sleep 1 touch ${TMP} # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER echo "" > ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo " AFSP: ${COUNTRY} models " >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} #echo "
" >> ${HTML} echo " Filer models (& ontap levels / OS-versions) of ${COUNTRY} " >> ${HTML} echo "
" >> ${HTML} echo "
" >> ${HTML} echo " For internal use. (c) Atos `date +%Y` " >> ${HTML} echo "
" >> ${HTML} echo " 		" >> ${HTML} echo "
" >> ${HTML} echo "
" >> ${HTML} echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} DASHBOARDASUPCOL="" # Get all data from AFSPDBDIR ls -1 ${AFSPDBDIR}/[_0-9]*.asc| while read DBFILE do FILERCOL="" SERNRCOL="" REMCOL="" if [ -f ${DBFILE} ]; then echo -n "." DB_READ ${DBFILE} # SERIAL_NUMBER="${DB_SERIAL_NUMBER}" # CONTROLER_NAME="${DB_CONTROLER_NAME}" # MODEL_NAME="${DB_MODEL_NAME}" # Remove all whitespace (including tabs) from left to first word OS_VERSION=`echo "${DB_OS_VERSION}"|sed -e 's/^[ \t]*//'` # SNMPLOC="${DB_SNMP_LOCATION}" # SNMPCONTACT="${DB_SNMP_CONTACT}" # PARTNER="${DB_PARTNER_HOSTNAME}" # LAST_ASUP="${DB_ASUP_GENERATED_ON}" # SYSTEMID="${DB_SYSTEM_ID}" # DFM_SERVERNAME="${DB_DFM_SERVERNAME}" # DFM_UPDATE_DATE="${DB_DFM_UPDATE_DATE}" # REMARKS="${DB_REMARKS}" # CONTRACT_NAME="${DB_CONTRACT_NAME}" # SITE_NAME="${DB_SITE_NAME}" # CONTACT_NAME=${DB_CONTACT_NAME} OSCOL="" case ${OS_VERSION} in 7.2*) OSCOL="red" ;; 7.3*) OSCOL="red" ;; 8.0*) OSCOL="orange" ;; 8.1*) OSCOL="orange" ;; 8.2*) OSCOL="orange" ;; 8.3*) OSCOL="yellow" ;; 9.*) OSCOL="lightgreen" ;; esac echo ${OS_VERSION}|grep 'RC' 1> /dev/null RC=${?} if [ ${RC} -eq 0 ]; then OSCOL="red" fi # If OS_VERSION == (also P-nr) as agreed release in FILEREOSSW ANSW="`grep '${OS_VERSION};' ${FILEREOSSW}|grep -v ^#`" if [ "${ANSW}" != "" ]; then OSCOL="green" fi # If OS_VERSION nearly (not P-nr) as agreed release in FILEREOSSW ANSW="`grep '${OS_VERSION}' ${FILEREOSSW}|grep -v ^#`" if [ "${ANSW}" != "" ]; then OSCOL="lightgreen" VERSION=`echo ${ANSW}|awk -F\; '{print $2}'` fi #echo "${DB_CONTROLER_NAME} ${OS_VERSION} ANSW=${ANSW} OSCOL=${OSCOL}" # echo "OS_VERSION=${OS_VERSION} | OSCOL=${OSCOL} ... " # -- Coloring # is model = know. color if [ "${DB_MODEL_NAME}" != "" ]; then MODELCOL="" THISYEAR=`date +%Y` EOSHW_DATE="`grep ${DB_MODEL_NAME} ${FILEREOS}|grep -v ^#|awk -F\; '{print $2}'|sort -u|head -1|sed 's/ //g'`" EOSYEAR="`grep ${DB_MODEL_NAME} ${FILEREOS}|grep -v ^#|awk -F\; '{print $2}'|sort -u|head -1|cut -d\- -f1`" NOW_EPOCH=`date +%s` YR1_EPOCH=`date +%s --date='1 year'` YR2_EPOCH=`date +%s --date='2 year'` YR3_EPOCH=`date +%s --date='3 year'` EOSHW_EPOCH=`date +%s --date=${EOSHW_DATE}` # echo "EOSHW_EPOCH=${EOSHW_EPOCH} NOW_EPOCH=${NOW_EPOCH} YR1_EPOCH=${YR1_EPOCH} YR2_EPOCH=${YR2_EPOCH} YR3_EPOCH=${YR3_EPOCH}" # EOS in the past if [ ${EOSHW_EPOCH} -le ${NOW_EPOCH} ]; then # echo "EOSHW_EPOCH=${EOSHW_EPOCH} <= NOW_EPOCH=${NOW_EPOCH} => RED" MODELCOL="red" fi # EOS within 1 year if [ ${EOSHW_EPOCH} -gt ${NOW_EPOCH} ]; then # echo "EOSHW_EPOCH=${EOSHW_EPOCH} > NOW_EPOCH=${NOW_EPOCH} => ORANGE" MODELCOL="orange" fi # EOS within 2 years if [ ${EOSHW_EPOCH} -gt ${YR1_EPOCH} ]; then # echo "EOSHW_EPOCH=${EOSHW_EPOCH} > YR1_EPOCH=${YR1_EPOCH} => YELLOW" MODELCOL="yellow" fi # EOS within 3 years if [ ${EOSHW_EPOCH} -gt ${YR2_EPOCH} ]; then # echo "EOSHW_EPOCH=${EOSHW_EPOCH} > YR2_EPOCH=${YR1_EPOCH} => GREEN" MODELCOL="green" fi if [ "${EOSHW_DATE}" = "" ]; then MODELCOL="lightblue" fi fi # DB_MODEL_NAME # echo "DB_MODEL_NAME=${DB_MODEL_NAME} EOSYEAR=${EOSYEAR} MODELCOL=${MODELCOL}" # Last ASUP LASTASUPOCOL="" YEAR="`date +%Y`" ANSW="`echo "${DB_ASUP_GENERATED_ON}"| grep \" ${YEAR}\"`" if [ "${ANSW}" = "" ]; then LASTASUPCOL="red" fi ANSW="`echo "${DB_ASUP_GENERATED_ON}"| grep \" ${YEAR}\"`" if [ "${ANSW}" != "" ]; then LASTASUPCOL="orange" fi MONTH="`date +%b`" ANSW="`echo ${DB_ASUP_GENERATED_ON}| grep \" ${YEAR}\"|grep \" ${MONTH}\"`" if [ "${ANSW}" != "" ]; then LASTASUPCOL="yellow" fi DAY="`date +%d`" ANSW="`echo ${DB_ASUP_GENERATED_ON}| grep \" ${YEAR}\"|grep \" ${MONTH}\"|grep \" ${DAY}\"`" if [ "${ANSW}" != "" ]; then LASTASUPCOL="green" fi if [ "${DB_ASUP_GENERATED_ON}" = "" ]; then LASTASUPCOL="lightblue" DASHBOARDASUPCOL="lightblue" # EMPTY_ASUP_CNT let "EMPTY_ASUP_CNT= ${EMPTY_ASUP_CNT} + 1" fi ANSW=`echo ${DB_ASUP_GENERATED_ON}|egrep 'UTC 20|GMT 20'` if [ "${ANSW}" != "" ]; then # UTC found. Can be wrong! (std install in stead of country LASTASUPCOL="purple" echo "UTC or GMT found at system: ${DB_CONTROLER_NAME} (${DB_SERIAL_NUMBER}) in ${COUNTRY} = ${DB_ASUP_GENERATED_ON}" |tee -a ${TMP} echo "" >> ${TMP} fi # ANSW # echo "DB_ASUP_GENERATED_ON=${DB_ASUP_GENERATED_ON} DAY=${DAY} MONTH=${MONTH} YEAR=${YEAR} ANSW=${ANSW} LASTASUPCOL=${LASTASUPCOL}" case "${LASTASUPCOL}" in "") DASHBOARDASUPCOL="lightblue" ;; "purple") DASHBOARDASUPCOL="purple" ;; "orange") if [ "${DASHBOARDASUPCOL}" = "" ] || [ "${DASHBOARDASUPCOL}" = "green" ] || [ "${DASHBOARDASUPCOL}" = "yellow" ]; then DASHBOARDASUPCOL="orange" fi ;; "yellow") if [ "${DASHBOARDASUPCOL}" = "" ] || [ "${DASHBOARDASUPCOL}" = "green" ]; then DASHBOARDASUPCOL="yellow" fi ;; "green") if [ "${DASHBOARDASUPCOL}" = "" ]; then DASHBOARDASUPCOL="green" fi ;; esac # DFM -server & last update # DB_DFM_SERVERNAME # DB_DFM_UPDATE_DATE if [ "${DB_DFM_SERVERNAME}" != "" ]; then DFMCOL="lightgreen" else DFMCOL="lightblue" fi CURDATE="`date +%Y-%m-%d`" if [ "${DB_DFM_UPDATE_DATE}" = "" ]; then LASTDFMCOL="lightblue" fi if [ "${DB_DFM_UPDATE_DATE}" = "${CURDATE}" ]; then LASTDFMCOL="green" fi if [ "${DB_REMARKS}" != "" ]; then REMCOL="yellow" fi # if no more information, maybe filer need to be removed if [ "${DB_ASUP_GENERATED_ON}" = "" ] && [ "${DB_DFM_SERVERNAME}" = "" ] && [ "${DB_DFM_UPDATE_DATE}" = "" ] && [ "${DB_REMARKS}" = "" ]; then FILERCOL="orange" SERNRCOL="orange" fi # echo "${DB_SERIAL_NUMBER} (${DB_CONTROLER_NAME}) | EOSYEAR=${EOSYEAR} SUPYEARS=${SUPYEARS} => ${MODELCOL}, LastASUP=${LASTASUPCOL} (${DASHBOARDASUPCOL}) ..." echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} # echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} # echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} # echo " " >> ${HTML} # echo " " >> ${HTML} echo " " >> ${HTML} # echo " " >> ${HTML} echo "" >> ${HTML} let "FILECNT= ${FILECNT} +1 " fi # -f DBFILE done # ls -1 echo " ${FILECNT} files processed."|tee -a ${LOG} sleep 1 echo "DASHBOARDASUPCOL=${DASHBOARDASUPCOL}"|tee -a ${DASHBOARDFILE} echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} #echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} #echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} #echo " " >> ${HTML} #echo " " >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} #COUNT="`cat ${IN}|grep -v '^#'|wc -l|awk '{print $1}'`" echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} echo "

" >> ${HTML} echo "

ASUP: ASUP: ASUP: ASUP: Admin: ASUP: ASUP: ASUP: ASUP: Admin: Admin: Admin: Admin:
Serial Number: Name: Last ASUP: Model: EOS HW: OS Version: Partner: SNMP location: SNMP contact: Contract name: Site name: Contact name: Remarks:
${DB_SERIAL_NUMBER} ${DB_CONTROLER_NAME} ${DB_ASUP_GENERATED_ON} ${DB_MODEL_NAME} ${EOSHW_DATE} ${OS_VERSION} ${FWVERSION} ${DB_PARTNER_HOSTNAME} ${DB_SNMP_LOCATION} ${DB_SNMP_CONTACT} ${USAGE} ${DB_CONTRACT_NAME} ${DB_SITE_NAME} ${DB_CONTACT_NAME} ${DB_DFM_SERVERNAME} ${DB_DFM_UPDATE_DATE} ${DB_REMARKS} ${ACKFILEDATI}
Serial Number: Name: Model: EOS HW: OS Version: BIOS Version: Partner: SNMP location: SNMP contact: Usage: Last ASUP: Contract name: Site name: Contact name: DFM-servername: Last DFM
update: 		Remarks:
${FILECNT} systems ${EMPTY_ASUP_CNT} empty ASUPs
" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo "
Color legenda:
Serial Number & Name: No ASUP & DFM info
Model: EOS reached EOS < 1 yr EOS < 2 yr EOS >= 3 yr No info
OS Version: Oldest (7.x / RC) Older (8.[012]) Old (8.3) 9.x and same rel. (not same P) Agreed rel. (incl P)
Last ASUP: Not this year This year This month This day No information UTC / GMT in date. Maybe wrong DASHBOARDASUPCOL=${DASHBOARDASUPCOL}
" >> ${HTML} echo "" >> ${HTML} echo " " >> ${HTML} echo " " >> ${HTML} echo "" >> ${HTML} echo "
" >> ${HTML} echo " " >> ${HTML} echo "
" >> ${HTML} echo "Contact: |Content Owner: Maarten de Boer |Last Update: `date`|[${PGM} v${VER}]
" >> ${HTML} echo "For internal use (c) Atos S.A. `date +%Y` all rights reserved. Reproduction in whole or in part is prohibited without the written consent of Atos SA." >> ${HTML} echo "
" >> ${HTML} echo " " >> ${HTML} echo "
" >> ${HTML} echo "" >> ${HTML} echo "" >> ${HTML} if [ -s ${TMP} ]; then cat ${TMP} |mailx -s "AFSP: Systems (in ${COUNTRY}) with UTC / GMT [${PGM} v${VER}]" ${MAILTO} echo " Mailed to ${MAILTO}"|tee -a ${LOG} fi rm ${TMP} echo "`date` ${PGM} finished." | tee -a ${LOG} exit 0