AFSP vs NetApp

#!/bin/ksh # File : upd_afsp_vs_netapp.sh # By : Maarten.deBoer@Atos.net, 2019-06-27 # Subject : Script to update web-file with compare between AFSP-ASUP vs NetApp-SAM-data # set -x PGM="`basename $0|cut -d\. -f1`" VER="0.1" TMP="/tmp/${PGM}.$$" TODATE=`date +%Y-%m-%d` AFSPDIR="/appl/mdr/mdrglob/afsp" BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`" LOG="${BASEDIR}/log/${PGM}.log" ASUPDBDIR="${AFSPDIR}/asup/data/database" NETAPPDBDIR="${AFSPDIR}/netapp/data/database" DBFILENAME="" ##COUNTRY2ASUP="${AFSPDIR}/glob/data/country2asup.csv" ALLSERNRS="${AFSPDIR}/glob/data/allsernrs.csv" PAGE="/appl/mdr/www/afsp/afsp_vs_netapp.html" COUNTRYDIR="`echo ${BASEDIR}| cut -d\/ -f6`" if [ ${COUNTRYDIR} != "glob" ]; then echo " COUNTRYDIR= NOT glob. Wrong DIR. Exiting ..." exit 3 fi echo "`date` ${PGM} v${VER} started." | tee -a ${LOG} echo "AFSPDIR=${AFSPDIR}" echo "BASEDIR=${BASEDIR}" echo "LOG=${LOG}" echo "PAGE=${PAGE}" echo "ASUPDBDIR=${ASUPDBDIR}" echo "NETAPPDBDIR=${NETAPPDBDIR}" echo "ALLSERNRS=${ALLSERNRS}" sleep 1 touch ${TMP} echo " Writing to ${PAGE} ..." # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER SKIP="1" #SKIP="" # Check if Date of File ALLSERNRS not is today. If, then skip. Otherwise make new FILEDATE=`stat --printf=%y ${ALLSERNRS}|awk '{print $1}'` echo "|${FILEDATE}|${TODATE}|" if [ "${FILEDATE}" != "${TODATE}" ]; then echo "Collecting ALL ser.nrs of all countries; ser.nr ..." sleep 1 echo "# DB_SERIAL_NUMBER;COUNTRY;DB_CONTROLER_NAME;DB_SYSTEM_ID;" > ${ALLSERNRS} echo "Getting COUNTRY data ..." for COUNTRY in `cd ${AFSPDIR}; 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} if [ "${DB_SERIAL_NUMBER}" = "" ]; then # No Ser>nr, then SysID DISPLAYNR="_${DB_SYSTEM_ID}" else DISPLAYNR="${DB_SERIAL_NUMBER}" fi echo "${DISPLAYNR};${COUNTRY};${DB_CONTROLER_NAME};${DB_SYSTEM_ID};" >> ${ALLSERNRS} done # DBFILE done # COUNTRY echo "" COUNTRY="netapp" echo "Getting NetApp data ..." for DBFILE in `ls -1 /appl/mdr/mdrglob/afsp/netapp/data/database/[_0-9]*.asc` do echo -n "." DB_READ ${DBFILE} echo "${DB_NA_SERIAL_NUMBER};${COUNTRY};${DB_NA_SYSTEM_NAME};;" >> ${ALLSERNRS} done # DBFILE echo "# `date` by ${PGM} v${VER} at ${HOSTNAME} " >> ${ALLSERNRS} fi # SKIP echo "" > ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "AFSP vs NetApp" >> ${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 "
AFSP vs NetApp
" >> ${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} # MAIN loop echo "MAIN loop (getting info from the Ser.Nrs) ..." sleep 1 cat ${ALLSERNRS}|grep -v ^#|sort -n|awk -F\; '{print $1" "$2}'|while read SERNR COUNTRY REST do echo -n "${COUNTRY}:${SERNR}>" if [ "${COUNTRY}" = "netapp" ]; then DBFILE="${NETAPPDBDIR}/${SERNR}.asc" else DBFILE="${ASUPDBDIR}/${SERNR}.asc" fi # netapp # echo - "${DBFILE} " if [ -f ${DBFILE} ]; then # echo -n "." DB_READ ${DBFILE} echo -n "${DB_SERIAL_NUMBER}=${DB_NA_SERIAL_NUMBER}" # 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} fi # -f DBFILE echo "" done # MAIN loop echo "" echo "

Serial Number:

Ctry:

(Atos) Controler Name:

(Atos) Last ASUP:

(NetApp) Last ASUP:

(NetApp) ASUP Status:

(NetApp) ASUP Reason:

(NetApp) Contact:

(NetApp) Country:

${SERNR}

${COUNTRY}

${DB_CONTROLER_NAME}

${DB_ASUP_GENERATED_ON}

${DB_NA_LAST_ASUP}

${DB_NA_SYSTEM_NAME}

${DB_NA_PLATFORM}

${DB_NA_OS_VERSION}

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

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