#!/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 PGM="`basename $0|cut -d\. -f1`" VER="0.13" 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/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} echo "BASEDIR=${BASEDIR}" echo "DBDIR=${DBDIR}" touch ${TMP} # Read Functions file source ./afsp-db_functions.sh DB_FUNC_VER # Create PAGE echo "" > ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " uptime history " >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo "" >> ${OUT} echo " " >> ${OUT} echo "
" >> ${OUT} echo " Filer uptime (in days) history of ${COUNTRY} " >> ${OUT} echo "
" >> ${OUT} echo "
" >> ${OUT} echo " For internal use. (c) Atos BTN 2015 " >> ${OUT} echo "
" >> ${OUT} echo " 		" >> ${OUT} echo "
" >> ${OUT} cd ${BASEDIR}/data/uptime/ echo "" >> ${OUT} # Header echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} ls -1dr 20*|head -n ${NRWEEKS}|while read WEEK do echo " " >> ${OUT} done # ls echo "" >> ${OUT} # Get all filers 1st # Skip "empty" (;;) line cat */*uptime.csv|grep -v ^#|grep -v ';;'|awk -F\; '{print $1}'|sort -u|while read FILER REST do echo "" >> ${OUT} echo "${FILER} ..." 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} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} # Then get history info from the FILER PREVWEEK="" 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} ${UPTIMEDAYS}" UPCOL="" 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 [ ${UPTIMEDAYS} -eq ${PREVWEEK} ]; then UPCOL="pink" fi 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 # echo " " >> ${OUT} echo " " >> ${OUT} done # ls -1dr echo "" >> ${OUT} done # cat # Footer echo "" >> ${OUT} echo -n "# Filer ; Uptime;" >> ${TMP} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} ls -1dr 20*|head -n ${NRWEEKS}| while read WEEK do echo -n "${WEEK};" >> ${TMP} echo " " >> ${OUT} done # ${WEEK} echo "" >> ${TMP} echo "" >> ${OUT} # Count nr filers / week echo "" >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} echo " " >> ${OUT} ls -1dr 20*|head -n ${NRWEEKS}| while read WEEK do echo -n "${WEEK};" >> ${TMP} CNT="`cat ${WEEK}/*.csv|grep -v ^#|awk -F\; '{print $1}'|sort -u|wc -l`" echo " " >> ${OUT} done # ${WEEK} echo "" >> ${TMP} echo "" >> ${OUT} echo "
Filer: SerNr: Model: OS version: ${WEEK}
${FILER} ${DB_SERIAL_NUMBER} ${DB_MODEL_NAME} ${DB_OS_VERSION} ${UPTIMEDAYS} ${UPTIMEDAYS} ${SPAN}
Filer: SerNr: Model: OS version: ${WEEK}
Filer count: ${CNT}
" >> ${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: 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
" >> ${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. `date +%Y` 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} ##cat ${TMP} rm ${TMP} echo "`date` ${PGM} finished."|tee -a ${LOG} exit 0