AFSP:NetApp-systems

#!/bin/ksh # File : upd_netapp_systems.sh # By : Maarten.deBoer@Atos.net, 2017-12-28 # Subject : Script to update web-file for systems from the NetApp DB # set -x #(0.2),190626 : Mod. EOS_ & ASUP add's PGM="`basename $0|cut -d\. -f1`" VER="0.2" TMP="/tmp/${PGM}.$$" BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" LOG="${BASEDIR}/log/${PGM}.log" NETAPPDBDIR="${BASEDIR}/data/database" DBFILENAME="" COUNTRY2ASUP="${BASEDIR}/data/country2asup.csv" PAGE="/appl/mdr/www/afsp/netapp-systems.html" COUNTRYDIR="`echo ${BASEDIR}| cut -d\/ -f6`" if [ ${COUNTRYDIR} != "netapp" ]; then echo " COUNTRYDIR= NOT netapp . Wrong DIR. Exiting ..." exit 3 fi echo "`date` ${PGM} v${VER} started." | tee -a ${LOG} echo "BASEDIR=${BASEDIR}" sleep 1 touch ${TMP} echo " Writing to ${PAGE} ..." # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER echo "" > ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "AFSP:NetApp-systems" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo " " >> ${PAGE} echo "" >> ${PAGE} #echo "

" >> ${PAGE} echo " NetApp (ONTAP) systems " >> ${PAGE} echo "
" >> ${PAGE} echo "
From NetApp SAM report(s)
" >> ${PAGE} echo "
Page update: `date`
" >> ${PAGE} echo "

" >> ${PAGE} echo " For internal use. (c) Atos BTN `date +%Y` " >> ${PAGE} echo "

" >> ${PAGE} echo "

" >> ${PAGE} echo "" >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo "" >> ${PAGE} SKIP="no" #SKIP="" if [ ${SKIP} ]; then echo "Collecting of all countries; hostname & ser.nr ..." echo "# COUNTRY;DB_CONTROLER_NAME;DB_SERIAL_NUMBER;DB_SYSTEM_ID;" > ${COUNTRY2ASUP} echo "Getting COUNTRY data ..." sleep 1 for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??` do echo -n " ${COUNTRY} " for DBFILE in `ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/[_0-9]*.asc` do DB_READ ${DBFILE} echo "${COUNTRY};${DB_CONTROLER_NAME};${DB_SERIAL_NUMBER};${DB_SYSTEM_ID};" >> ${COUNTRY2ASUP} done # DBFILE done # COUNTRY echo "" fi # SKIP # MAIN loop echo "MAIN loop (processing ASUP-DB) ..." sleep 1 for DBFILE in `ls -1 ${NETAPPDBDIR}/[_0-9]*.asc` do # echo " ${DBFILE}" DB_READ ${DBFILE} # Get country for NetApp Ser.Nr if [ "${DB_NA_SERIAL_NUMBER}" != "" ]; then COUNTRYNAME="`grep ${DB_NA_SERIAL_NUMBER} ${COUNTRY2ASUP}|awk -F\; '{print $1}'|sort -u|head -1`" fi # DB_SERIAL_NUMBER CTRYCOL="" if [ "${COUNTRYNAME}" = "" ]; then CTRYCOL="yellow" else COUNTRYURL="${COUNTRYNAME}/models.html" fi # COUNTRYNAME GRPCOL="" if [ "${DB_NA_GROUP_NAME}" = "" ]; then GRPCOL="yellow" fi # Check for ATOS_ . If right, then OK ANSW=`echo ${DB_NA_GROUP_NAME}|grep ^ATOS_` if [ "${ANSW}" != "" ]; then GRPCOL="lightgreen" fi YEAR=`date +%Y` YEAR1=`date +%Y --date=1year` MONTH=`date +%b` DAY=`date +%d` # EOSCOL="" # EOSYEAR=`echo "${DB_NA_EOS_DATE}"|cut -d\, -f2` # if [ "${EOSYEAR}" != "" ]; then # When less then this year, RED (no Support) # if [ ${EOSYEAR} -lt ${YEAR} ]; then # EOSCOL="red" # fi # if [ ${EOSYEAR} -eq ${YEAR} ]; then # EOSCOL="orange" # fi # if [ ${EOSYEAR} -eq ${YEAR1} ]; then # EOSCOL="yellow" # fi # if [ ${EOSYEAR} -gt ${YEAR1} ]; then # EOSCOL="lightgreen" # fi # fi # ! EOSYEAR ASUPCOL="" if [ "${DB_NA_ASUP_STATUS}" = "OFF" ]; then ASUPCOL="red" fi if [ "${DB_NA_ASUP_STATUS}" = "DECLINE" ]; then ASUPCOL="orange" fi if [ "${DB_NA_ASUP_STATUS}" = "ON" ]; then ASUPCOL="lightgreen" fi DISPLAY_NR="${DB_NA_SERIAL_NUMBER}" # When SerNr = then use SystemID if [ "${DISPLAY_NR}" = "" ]; then DISPLAY_NR="_${DB_SYSTEM_ID}" fi if [ "${DISPLAY_NR}" != "" ]; then let "CNT=${CNT} + 1" echo " ${CNT} - ${DISPLAY_NR} ..." echo "" >> ${PAGE} echo " " >> ${PAGE} # echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} # echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} echo " " >> ${PAGE} echo "" >> ${PAGE} fi done # MAIN loop echo "" >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} #echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo "" >> ${PAGE} echo " ${CNT} system(s) found in ${NETAPPDBDIR}"|tee -a ${LOG} echo "" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} # echo " " >> ${PAGE} echo "" >> ${PAGE} echo "

" >> ${PAGE} echo "

Ctry:

Group name:

Serial Number:

System Name:

Platform:

EOS:

OS Version:

Last (NetApp) ASUP:

ASUP Suport status:

ASUP Declined reason:

Contact name:

Contact number:

Contact mail:

Serv.Rpt Addr:

Serv.Rpt City:

Serv.Rpt P.Code:

Serv.Rpt County:

SERVICE LEVEL

ENTITLEMENT STATUS

Installed at:

Contract:

Ctry:

${COUNTRYNAME}

${DB_NA_GROUP_NAME}

${DISPLAY_NR}

${DB_NA_SYSTEM_NAME}

${DB_NA_PLATFORM}

${DB_NA_EOS_DATE}

${DB_NA_OS_VERSION}

${DB_NA_LAST_ASUP}

${DB_NA_ASUP_STATUS}

${DB_NA_ASUP_DECLINED_REASON}

${DB_NA_PRIM_CONTACT_NAME}

${DB_NA_PRIM_CONTACT_NUMBER}

${DB_NA_PRIM_CONTACT_MAIL}

${DB_NA_SERVICE_REPORT_TO_ADDRESS}

${DB_NA_SERVICE_REPORT_TO_CITY}

${DB_NA_SERVICE_REPORT_TO_POSTAL_CODE}

${DB_NA_SERVICE_REPORT_TO_COUNTRY}

${DB_NA_SERVICE_LEVEL}

${DB_NA_ENTITLEMENT_STATUS}

${DB_NA_INSTALLED_AT}

${DB_NA_CONTRACT}

${COUNTRYNAME}

Ctry:

Group name:

Serial Number:

System Name:

Platform:

EOS:

OS Version:

Last (NetApp) ASUP:

ASUP Suport status:

ASUP Declined reason:

Contact name:

Contact number:

Contact mail:

SERVICE LEVEL

ENTITLEMENT STATUS

Installed at:

Contract:

Serv.Rpt Addr:

Serv.Rpt City:

Serv.Rpt P.Code:

Serv.Rpt County:

Ctry:

${CNT} systems

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

Legenda:
Country:	NO country found
Group name:	NO group name found	ATOS_ group name
EOS:	Not this(${YEAR}) year	This year	Next(${YEAR1}) year	After next year
Last ASUP:	OFF	DECLINE	ON

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

" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo "Contact: |Content Owner: Maarten de Boer |Last Update: `date` [${PGM} v${VER}]
" >> ${PAGE} 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." >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo "

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