uptime history

#!/bin/sh # File : upd_uptime.sh # By : Maarten.deBoer@Atos.net, 150324 # Subject : Script to process history #(0.1) : From proc_history #(0.2) : Added comments at RED #(0.3) : Mod. labels #(0.4) : Add COUNTRY #(0.5) : Add check if 2 uptimedayvaules #(0.6) : Added # filers at the end #(0.7) : Removed Location & Usage #(0.8) : Added Ser.Nr & Model #(0.9) : Mod. colors #(0.10) : Mod. green -> lightgreen #(0.11) : Mod. 0 = pink #(0.12) : Mod; When time = same as previous, pink #(0.13) : Mod; lightblue when [?] and 0 #(0.14) : Mod "unary operator expected", "${UPTIMEDAYS}" != "" #(0.15) : Mod; uptime filers from DBDATA in stead of .csv's, ${OUT} -> ${PAGE} #(0.16),180531 : Added LAST_asup #(0.17),200622 : Mod. cellspacing='0' #(0.18),220824 : Mod. "NOT supported" PGM="`basename $0|cut -d\. -f1`" VER="0.18" 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" PAGE="${BASEDIR}/html/uptime.html" DBDIR="${BASEDIR}/data/database" COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`" # Number of Month #NRWEEKS=24 NRWEEKS=20 echo "`date` ${PGM} v${VER} started."|tee -a ${LOG} touch ${TMP} echo "BASEDIR=${BASEDIR}" echo "COUNTRY=${COUNTRY}" echo "DBDIR=${DBDIR}" echo "NRWEEKS=${NRWEEKS}" echo "PAGE=${PAGE}" # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER sleep 1 # Create PAGE echo "" > ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo " uptime history " >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo "" >> ${PAGE} echo " " >> ${PAGE} echo "

" >> ${PAGE} echo " Filer uptime (in days) history of ${COUNTRY} " >> ${PAGE} echo "
" >> ${PAGE} echo " NOT maintained anymore " >> ${PAGE} echo " Because the other way (HTTPS) of delivery is not supported by AFSP (old way is SMTP). " >> ${PAGE} echo "

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

" >> ${PAGE} echo "

" >> ${PAGE} echo "" >> ${PAGE} # Header echo "" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} cd ${BASEDIR}/data/uptime/ ls -1dr 20*|head -n ${NRWEEKS}|while read WEEK do echo " " >> ${PAGE} done # ls echo "" >> ${PAGE} # Get all systems from DB # If database, then cd to database if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ]; then cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ls -1 | while read DBFILE do echo "${DBFILE} ..." DB_READ /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/${DBFILE} echo "${DB_CONTROLER_NAME} ..." #cat */*uptime.csv|grep -v ^#|grep -v ';;'|awk -F\; '{print $1}'|sort -u|while read ${DB_CONTROLER_NAME} REST #do # if [ -d ${DBDIR} ]; then # SERNR="`grep -i ${FILER} ${DBDIR}/*.asc|grep CONTROLER_NAME|cut -d\. -f1|head -1`" # if [ "${SERNR}" != "" ]; then # DBFILE="${SERNR}.asc" # DB_READ ${DBFILE} # fi # fi # -d ${DBDIR} # 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 "" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} FILER="${DB_CONTROLER_NAME}" # Then get history info from the FILER PREVWEEK="" cd ${BASEDIR}/data/uptime/ ls -1dr 20*|head -n ${NRWEEKS}|while read WEEK REST do UPTIMEDAYS1="`grep \"${FILER}\;\" ${WEEK}/*uptime.csv|head -1|awk -F\; '{print $2}'|sed 's/ //g'|sed 's/days//g'|sed 's/day//g'`" UPTIMEDAYS2="`grep \"${FILER}\;\" ${WEEK}/*uptime.csv|head -2|tail -1|awk -F\; '{print $2}'|sed 's/ //g'|sed 's/days//g'|sed 's/day//g'`" if [ ${UPTIMEDAYS1} -ne ${UPTIMEDAYS2} ]; then if [ ${UPTIMEDAYS1} -lt ${UPTIMEDAYS2} ]; then UPTIMEDAYS="${UPTIMEDAYS2}" else UPTIMEDAYS="${UPTIMEDAYS1}" fi # -le else UPTIMEDAYS="${UPTIMEDAYS1}" fi # -ne echo "Week:${WEEK} ${UPTIMEDAYS}days" UPCOL="" if [ "${UPTIMEDAYS}" != "" ]; then if [ ${UPTIMEDAYS} -le 365 ]; then UPCOL="lightgreen" fi if [ ${UPTIMEDAYS} -lt 28 ]; then UPCOL="yellow" fi if [ ${UPTIMEDAYS} -lt 21 ]; then UPCOL="orange" fi # Check if cur day is Eq as other, then someting wrong if [ "${PREVWEEK}" != "" ]; then if [ ${UPTIMEDAYS} -eq ${PREVWEEK} ]; then UPCOL="pink" fi fi # "${PREVWEEK}" != "" PREVWEEK=${UPTIMEDAYS} if [ "${UPTIMEDAYS}" = "" ]; then UPCOL="" fi SPAN="" if [ ${UPTIMEDAYS} -lt 14 ]; then UPCOL="red" if [ -f ${WEEK}/info.csv ]; then INFO="`grep ${FILER} ${WEEK}/info.csv|awk -F\; '{print $2}'`" if [ "${INFO}" != "" ]; then SPAN="[?]" UPCOL="lightblue" fi # SPAN else UPCOL="red" fi # comments fi if [ ${UPTIMEDAYS} -eq 0 ]; then UPCOL="pink" if [ "${INFO}" != "" ]; then SPAN="[?]" UPCOL="lightblue" fi # SPAN fi if [ ${UPTIMEDAYS} -gt 365 ]; then UPCOL="yellow" fi if [ ${UPTIMEDAYS} -gt 730 ]; then UPCOL="orange" fi fi # UPTIMEDAYS != "" # echo " " >> ${PAGE} echo " " >> ${PAGE} done # ls -1dr echo "" >> ${PAGE} done # DBREAD fi # database # Footer echo "" >> ${PAGE} echo -n "# Filer ; Uptime;" >> ${TMP} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} cd ${BASEDIR}/data/uptime/ ls -1dr 20*|head -n ${NRWEEKS}| while read WEEK do echo -n "${WEEK};" >> ${TMP} echo " " >> ${PAGE} done # ${WEEK} echo "" >> ${TMP} echo "" >> ${PAGE} # Count nr filers / week # No count of filers since 0.15. Does not work with CSV`` if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ]; then echo "" >> ${PAGE} echo " " >> ${PAGE} cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database CNT=`ls -1 *.asc|wc -l` echo " " >> ${PAGE} echo "" >> ${TMP} echo "" >> ${PAGE} fi # DB found echo "

SerNr:	Name:	Last ASUP:	Model:	OS version:	${WEEK}
${DB_SERIAL_NUMBER}	${DB_CONTROLER_NAME}	${DB_ASUP_GENERATED_ON}	${DB_MODEL_NAME}	${DB_OS_VERSION}	${UPTIMEDAYS}	${UPTIMEDAYS} ${SPAN}
SerNr:	Name:	Last ASUP:	Model:	OS version:	${WEEK}
System count:	${CNT}

" >> ${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:
Last ASUP: Not this year This year This month This day No information UTC / GMT in date. Maybe wrong DASHBOARDASUPCOL=${DASHBOARDASUPCOL}
Has (mouse)hover-over information some error? (0 days or the same as other week) <14 days <21 days <28 days <365 days >365 days >730 days
" >> ${PAGE} echo "" >> ${PAGE} echo "

" >> ${PAGE} echo "" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo "" >> ${PAGE} echo "
" >> ${PAGE} echo " " >> ${PAGE} echo " " >> ${PAGE} echo "Contact: |Content Owner: Maarten de Boer |Last Update: `date`
" >> ${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} ##cat ${TMP} rm ${TMP} echo "`date` ${PGM} finished."|tee -a ${LOG} exit 0

Legenda:
Last ASUP:	Not this year	This year	This month	This day	No information	UTC / GMT in date. Maybe wrong	DASHBOARDASUPCOL=${DASHBOARDASUPCOL}
Has (mouse)hover-over information	some error? (0 days or the same as other week)	<14 days	<21 days	<28 days	<365 days	>365 days	>730 days