
#!/bin/sh
# File	: upd_dashboard.sh
# By	: Maarten.deBoer@Atos.net, 150421, 150817
# Subject	: Script to process global overwiew
#(0.2)	: Add netapp
#(0.3)	: Add cp @Overview
#(0.4)	: Add date of file
#(0.5)	: Add DFM-servers
#(0.6)	: Add failed disks
#(0.7)	: Update (rename upd_glob.sh)
#(0.8)	: Added if [ -d  's & renamed upd_dashboard.sh
#(0.9)	: Mod. uptime (ls -1d * ...)
#(0.10)	: Add list last incomming
#(0.11) : Change some layout
#(0.12)	: Changed layout
#(0.13)	: Upd Last
#(0.14)	: Mod.
#(0.15) : Failed disks
#(0.16)	: Add DASHBOARDASUPCOL
#(0.17)	: Add Aggr-usage
#(0.18)	: Mod; color uptime
#(0.19),160711	: Added totalaggrtb
#(0.20),160920	: Added grand TBs
#(0.21),161004	: Add % of filers
#(0.22),161228	: Add color @disk-failures, green -> lightgreen
#(0.23),721230	: Added netapp-filer-list_2016-09-06.csv
#(0.24),170419	: Mod. Cap.mgt colors + Legenda + DASHBOARDASUPCOL=""
#(0.25),170509	: Add %, if mods, Added CSV
#(0.26),170510	: Add --mail & MAIL
PGM="`basename $0|cut -d\. -f1`"
VER="0.26"
TMP="${PGM}.$$"
LOG="/appl/mdr/afsp/glob/log/${PGM}.log"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
OUT="${BASEDIR}/html/overview.html"
OUT="/appl/mdr/www/afsp/index.html"
DATE="`date +%Y-%m-%d`"
CSV="${BASEDIR}/data/afsp-dashboard_${DATE}.csv"
CSVMAILTO="maarten.deboer@atos.net"
MAIL="" 

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
cp /dev/null ${CSV}

if [ "${1}" = "--mail" ]; then
  MAIL=1
fi

echo "<!DOCTYPE html>" > ${OUT}
echo "<HTML>" >> ${OUT}
echo "<HEAD>" >> ${OUT}
echo "<META charset='UTF-8'>" >> ${OUT}
echo "<META content=Maarten de Boer name=AUTHOR>" >> ${OUT}
echo "<TITLE> AFSP:dashboard </TITLE>" >> ${OUT}
echo "<basefont face='verdana'>" >> ${OUT}
echo "</HEAD>" >> ${OUT}

echo "<BODY aLink=blue bgColor=#D3D0D3 link=blue text=#000000 vLink=blue>" >> ${OUT}

# --- Header

echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${OUT}

echo "<TR HEIGHT=40px>" >> ${OUT}
echo "  <TD bgColor=#0066A1>" >> ${OUT}
echo "    <FONT COLOR=white face='verdana' size='5'> <B>Atos (netapp/ibm) Filer Status Portal <BR>
Dashboard </B> </FONT>" >> ${OUT}
echo "    <BR>" >> ${OUT}
echo "    <DIV align=right>" >> ${OUT}
echo "    <FONT COLOR=white face='verdana' size='-3'> For internal use. (c) Atos BTN `date +%Y` </B> </FONT>" >> ${OUT}
echo "    </DIV>" >> ${OUT}
echo "  <TD>" >> ${OUT}
echo "</TR>" >> ${OUT}
echo "</TABLE>" >> ${OUT}


# ----------- MAIN

echo "<TABLE BORDER=1>" >> ${OUT}
echo "  <TR>" >> ${OUT}
echo "    <TD align='right'><FONT COLOR=black face='verdana' size='2'> Country -></FONT></TD>" >> ${OUT}
echo -n "COUNTRY;" >> ${CSV}
echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> global </TD>" >> ${OUT}
echo -n ";" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -f /appl/mdr/www/afsp/${COUNTRY}/index.html ]; then
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'><A HREF=\"${COUNTRY}/index.html\">${COUNTRY}</A></FONT></TD>" >> ${OUT}
  else
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'>${COUNTRY}</FONT></TD>" >> ${OUT}
  fi
# Add to CSV
  echo -n "${COUNTRY};" >> ${CSV}
done  # for
echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'>Total</FONT></TD>" >> ${OUT}

echo "  </TR>" >> ${OUT}
echo "Total;" >> ${CSV}


# From the filers
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='1'><B>From the filers</B></FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo -n "ASUPs;" >> ${CSV}
# ASUPs
TTLCNT=0
FILECNT="`cat /appl/mdr/mdrglob/afsp/glob/data/asup-data.csv|wc -l`"
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>ASUPs</FONT></TD>" >> ${OUT}
echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'><A HREF=\"asup-status.html\">${FILECNT}</A></FONT></TD>" >> ${OUT}
echo -n ";" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  CNT="`cat /appl/mdr/mdrglob/afsp/glob/data/country-asup-data.csv|grep -v ^#|grep \"${COUNTRY};\"|wc -l`"
  TTLCNT=`expr ${TTLCNT} + ${CNT}`
  echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'>${CNT}</FONT></TD>" >> ${OUT}
  echo -n "${CNT};" >> ${CSV}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo "${TTLCNT};" >> ${CSV}

# From AFSP
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='1'><B>From AFSP</B></FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
# Overview
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Overview</FONT></TD>" >> ${OUT}
echo "    <TD> </TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -f /appl/mdr/www/afsp/${COUNTRY}-overview.html ]; then
#    cp /appl/mdr/www/afsp/${COUNTRY}/overview.html /appl/mdr/www/afsp/${COUNTRY}-overview.html 
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}-overview.html\">O</A> </FONT></TD>" >> ${OUT}
  else
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'>  </FONT></TD>" >> ${OUT}
  fi
done  # for
echo "  </TR>" >> ${OUT}


# Models
TTLCNT=0
MODDATE=""
echo "  <TR>" >> ${OUT}

echo "    <TD><FONT COLOR=black face='verdana' size='-3'>LifeCylce mgt (models+version)</FONT></TD>" >> ${OUT}
echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'><A HREF=\"https://msssyscol01.atos-srv.net/SAN/GLOB/Global_AFSP_Dashboard_Layer203.html\">Best Practice-NetApp</A></FONT></TD>" >> ${OUT}
echo -n "Filer models; ;" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  CNT=0
  DASHBOARDASUPCOL="lightgrey"
  DASHBOARDFILE="/appl/mdr/mdrglob/afsp/${COUNTRY}/data/dashboard.asc"
  if [ -f ${DASHBOARDFILE} ]; then
    DASHBOARDASUPCOL="`grep DASHBOARDASUPCOL ${DASHBOARDFILE}|awk -F\= '{print $2}'`"
  else
    DASHBOARDASUPCOL="grey"
  fi
  if [ "${DASHBOARDASUPCOL}" = "" ]; then
    DASHBOARDASUPCOL="lightgrey"
  fi
  echo "${COUNTRY}: DASHBOARDASUPCOL=${DASHBOARDASUPCOL}|"
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version
    CNT="`cat *.csv|grep -v ^#|awk -F\; '{print $1}'|sort -u|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
  fi
  if [ ${CNT} -gt 0 ]; then
    echo "    <TD BGCOLOR=${DASHBOARDASUPCOL} align='center'><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/models.html\">${CNT}</A> </FONT></TD>" >> ${OUT}
  else
#    echo "    <TD BGCOLOR=${DASHBOARDASUPCOL} align='center'><FONT COLOR=black face='verdana' size='2'> ${CNT} </FONT></TD>" >> ${OUT}
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'></FONT></TD>" >> ${OUT}
  fi  # ${COUNTRY}
  echo -n "${CNT};" >> ${CSV}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "${TTLCNT}" >> ${CSV}
TTLCNTMODELS=${TTLCNT}
echo "  </TR>" >> ${OUT}

# Models %
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'> Models % </FONT></TD>" >> ${OUT} 
echo "    <TD> </TD>" >> ${OUT}
echo -n "Filer model % ; ;" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
  do
    if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version ]; then
      cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version
      CNT="`cat *.csv|grep -v ^#|awk -F\; '{print $1}'|sort -u|wc -l`"
      if [ ${CNT} -gt 0 ]; then
        PERC=`expr ${CNT} \* 100 / ${TTLCNTMODELS}`
      else
        PERC=0
	  fi
    fi
    if [ ${CNT} -gt 0 ]; then
      echo "    <TD align='center'><FONT COLOR=black face='verdana' size='0'> ${PERC}% (${CNT}/${TTLCNTMODELS}) </A> </FONT></TD>" >> ${OUT} 
    else
      echo "    <TD> </TD>" >> ${OUT} 
    fi  # CNT
# Add to CSV
    echo -n "${PERC} %;" >> ${CSV}
  done  # COUNTRY
echo "  </TR>" >> ${OUT}
echp "" >> ${CSV}


# Versions
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Release mgt (os-versions)</FONT></TD>" >> ${OUT} 
echo "    <TD> </TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  CNT=0
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/versions ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/versions
    LAST="`ls -1|tail -1`"
  fi
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/versions/${LAST} ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/versions/${LAST}
    CNT="`cat *.csv|grep -v ^#|awk -F\; '{print $1}'|sort -u|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
  fi
  if [ ${CNT} -gt 0 ]; then
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/versions.html\">${CNT}</A> </FONT></TD>" >> ${OUT} 
  else
#    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${CNT} </FONT></TD>" >> ${OUT}
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'></FONT></TD>" >> ${OUT}
  fi  # ${COUNTRY}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
TTLCNT=0
echo "${TTLCNT};" >> ${CSV}

# Patches
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Patch mgt
(disk-firmware)</FONT></TD>" >> ${OUT}
echo "    <TD> </TD>" >> ${OUT}
echo -n "Patches ; ;" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  CNT=0
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/firmware ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/firmware
    CNT="`cat *.csv|grep -v ^#|sort -u|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
  fi 
  if [ ${CNT} -gt 0 ]; then
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/disk-firmware.html\">${CNT}</A> </FONT></TD>" >> ${OUT} 
  else
#    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${CNT} </FONT></TD>" >> ${OUT}
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'></FONT></TD>" >> ${OUT}
  fi  # ${COUNTRY}
  echo -n "${CNT};" >> ${CSV}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo "${TTLCNT};" >> ${CSV}

# Uptime
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Availability mgt (uptime)</FONT></TD>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'># filers <BR> Lowest days up </TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime
    LAST="`ls -1d 2*|tail -1`"
  fi
  CNT=0
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime/${LAST} ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime/${LAST}
    CNT="`cat *.csv|grep -v ^#|awk -F\; '{print $1}'|sort -u|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
	LOWEST_UPTIME=0
	LOWEST_UPTIME="`cat /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime/${LAST}/*.csv|cut -d\; -f2|cut -d' ' -f1|sort -un|grep [0-9]|head -1`"
	AVAILBGCOL=""
	if [ ${LOWEST_UPTIME} -le 365 ]; then
	  AVAILBGCOL="lightgreen"
	fi
	if [ ${LOWEST_UPTIME} -lt 28 ]; then
	  AVAILBGCOL="yellow"
	fi
	if [ ${LOWEST_UPTIME} -lt 21 ]; then
	  AVAILBGCOL="orange"
	fi
	if [ ${LOWEST_UPTIME} -lt 14 ]; then
	  AVAILBGCOL="red"
	fi
	if [ ${LOWEST_UPTIME} -gt 365 ]; then
	  AVAILBGCOL="yellow"
	fi
	if [ ${LOWEST_UPTIME} -gt 730 ]; then
	  AVAILBGCOL="orange"
	fi
  fi
  if [ ${CNT} -gt 0 ]; then
    echo "    <TD align='center' BGCOLOR=${AVAILBGCOL} ><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/uptime.html\">${CNT}</A> <BR>${LOWEST_UPTIME}</FONT></TD>" >> ${OUT} 
  else
#    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'>${CNT}</FONT></TD>" >> ${OUT}
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'></FONT></TD>" >> ${OUT}
  fi  # ${COUNTRY}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}

# Aggr-usage (Cap.mgt)
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Cap. mgt (max. aggr usage) <BR>Total Aggr. TBs </FONT></TD>" >> ${OUT}
echo "    <TD> </TD>" >> ${OUT}
echo -n "Total Aggr [TB]; ;" >>  ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/
  if [ -f dashboard_highestperc.asc ]; then
    PERC="`cat dashboard_highestperc.asc`"
  else
    PERC=0
  fi
  if [ -f dashboard_totalaggrtb.asc ]; then
    TOTAL="`cat dashboard_totalaggrtb.asc`"
  else 
    TOTAL=0
  fi 
  if [ ${TOTAL} -gt 0 ]; then
    TTLCNT=`expr ${TTLCNT} + ${TOTAL}`
  fi

echo "- Aggr ${COUNTRY} = ${TOTAL} / ${TTLCNT} "
  echo -n "${TOTAL};" >> ${CSV}

  BGCOLOR="lightgreen"
  if [ ${PERC} -gt 0 ]; then
    if [ ${PERC} -ge 90 ]; then
      BGCOLOR="yellow"
    fi
    if [ ${PERC} -ge 95 ]; then
      BGCOLOR="orange"
    fi
    if [ ${PERC} -ge 100 ]; then
      BGCOLOR="red"
    fi

    echo "    <TD align='center' BGCOLOR=${BGCOLOR}><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/aggr-usage.html\">${PERC}%</A> <BR>" >> ${OUT}
	if [ ${TOTAL} -gt 0 ]; then
	  echo "${TOTAL}TB " >> ${OUT}``
	fi
	echo "</FONT></TD>" >> ${OUT}
  else
#    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${PERC} </FONT></TD>" >> ${OUT}
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> </FONT></TD>" >> ${OUT}
  fi  # ${CNT}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT}TB </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
TTLCNTAGGR=${TTLCNT}
echo "${TTLCNT}; " >> ${CSV}

# Aggr %
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'> Aggr % </FONT></TD>" >> ${OUT} 
echo "    <TD> </TD>" >> ${OUT}
echo -n "Total Aggr %; ;" >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/model-version ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/
    if [ -f dashboard_totalaggrtb.asc ]; then
      TOTAL="`cat dashboard_totalaggrtb.asc`"
    else
      TOTAL=0
    fi
    if [ ${TOTAL} -gt 0 ]; then
      PERC=`expr ${TOTAL} \* 100 / ${TTLCNTAGGR}`
    else
      PERC=0
    fi
  fi
  if [ ${TOTAL} -gt 0 ]; then
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='0'> ${PERC}% (${TOTAL}/${TTLCNTAGGR}) </A> </FONT></TD>" >> ${OUT} 
  else
    echo "    <TD> </TD>" >> ${OUT} 
  fi  # CNT
  echo -n "${PERC} %;" >> ${CSV}
done  # COUNTRY
echo "  </TR>" >> ${OUT}
echo "" >> ${CSV}

# Failed disks
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Failed disks</FONT></TD>" >> ${OUT}
echo "    <TD> </TD>" >> ${OUT}
echo -n "Failed disks; ; " >> ${CSV}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/
  CNT="`cat afsp-disks-failures.csv|grep -v ^#|wc -l`"
  TTLCNT=`expr ${TTLCNT} + ${CNT}`
  if [ ${CNT} -gt 0 ]; then
    BGCOLOR="yellow"
    if [ ${CNT} -gt 1 ]; then
      BGCOLOR="orange"
	fi
    echo "    <TD align='center' BGCOLOR=${BGCOLOR}><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/failed-disks.html\">${CNT}</A> </FONT></TD>" >> ${OUT}
  else
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${CNT} </FONT></TD>" >> ${OUT}
  fi  # ${CNT}
  echo -n "${CNT};" >> ${CSV}
done  # for
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}
echo "" >> ${CSV}

# From NetApp
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'><B>From NetApp</B></FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}

for NETAPPDATE in `echo "2016-09-06 2015-03-09"`
do
  echo "${NETAPPDATE} ..."
  FILENAME="/appl/mdr/mdrglob/afsp/netapp/data/netapp-filer-list_${NETAPPDATE}.csv"
  TTLCNT=0
  FILECNT="`cat ${FILENAME}|wc -l`"
  echo "  <TR>" >> ${OUT}
  echo "    <TD><FONT COLOR=black face='verdana' size='-3'> List (${NETAPPDATE})</FONT></TD>" >> ${OUT}
  echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${FILECNT} <BR> lines</FONT></TD>" >> ${OUT}
  for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
  do
    CNT="`cat ${FILENAME}|grep -v ^#|grep \";${COUNTRY};\"|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
    PERC=`expr ${CNT} \* 100 / ${FILECNT}`
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'>${CNT}</FONT><BR><FONT size='1'>${PERC}% </FONT></TD>" >> ${OUT}
  done  # for
  echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
  echo "  </TR>" >> ${OUT}

done  # for NETAPPDATE


# Compared list
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>Compare list</FONT></TD>" >> ${OUT}
echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'><A HREF=\"compare-list.html\">global</A></FONT></TD>" >> ${OUT}

for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -f /appl/mdr/www/afsp/${COUNTRY}/compare-list.html ]; then
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> <A HREF=\"${COUNTRY}/compare-list.html\">${COUNTRY}</A> </FONT></TD>" >> ${OUT}
  else
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'>  </FONT></TD>" >> ${OUT}
  fi
done  # for

echo "  </TR>" >> ${OUT}


# Internal / Diagnostics
TTLCNT=0
echo "  <TD><FONT COLOR=black face='verdana' size='-3'><B>Diagnostics</B></FONT></TD>" >> ${OUT}
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'>DB-files</FONT></TD>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-3'> </FONT></TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/
    CNT="`ls -1 *.asc|wc -l`"
    TTLCNT=`expr ${TTLCNT} + ${CNT}`
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${CNT} </FONT></TD>" >> ${OUT}
  else
    echo "    <TD align='center'><FONT COLOR=black face='verdana' size='2'> </FONT></TD>" >> ${OUT}
  fi

done  # COUNTRY
echo "  <TD align='center'><FONT COLOR=black face='verdana' size='2'> ${TTLCNT} </FONT></TD>" >> ${OUT}
echo "  </TR>" >> ${OUT}


# Diagnostics, Last versions
ETC="${BASEDIR}/etc/date-week-month.csv"
if [ -f ${ETC} ]; then
  DATE="`date +%F`"
  WEEK="`grep ${DATE} ${ETC}|awk -F\; '{print $2}'`"
  MONTH="`grep ${DATE} ${ETC}|awk -F\; '{print $3}'`"
  echo "${DATE} M:${MONTH} W:${WEEK}"
fi

echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-4'>Last os-versions</FONT></TD>" >> ${OUT}
  echo "    <TD align='center'><FONT COLOR=black face='verdana' size='-4'> ${MONTH} </FONT></TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  LASTDIR="`cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/versions/; ls -1d 20??m??|tail -1`"
  echo "    <TD align='center'><FONT COLOR=black face='verdana' size='-4'> ${LASTDIR} </FONT></TD>" >> ${OUT}
done  # COUNTRY
echo "  </TR>" >> ${OUT}

# Diagnostics, Last uptime
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-4'>Last uptime</FONT></TD>" >> ${OUT}
  echo "    <TD align='center'><FONT COLOR=black face='verdana' size='-4'> ${WEEK} </FONT></TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  LASTDIR="`cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/uptime/; ls -1d 20??w??|tail -1`"
  echo "    <TD align='center'><FONT COLOR=black face='verdana' size='-4'> ${LASTDIR} </FONT></TD>" >> ${OUT}
done  # COUNTRY
echo "  </TR>" >> ${OUT}

# DFM-server(s)name(s)
TTLCNT=0
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-4'>DFM-server(s)</FONT></TD>" >> ${OUT}
echo "    <TD> </TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  DFMCNT="`ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/incomming/2*/*.csv|cut -d\_ -f2|cut -d\. -f1|sort -u|wc -l`"
  DFMS="`ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/incomming/2*/*.csv|cut -d\_ -f2|cut -d\. -f1|sort -u`"
  if [ ${DFMCNT} -gt 0 ]; then
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='-4'>${DFMCNT}<BR> <SPAN title=\"${DFMS}\">[?]</SPAN></FONT></TD>" >> ${OUT}
  else
    echo "  <TD align='center'><FONT COLOR=black face='verdana' size='-4'>${DFMCNT}</FONT></TD>" >> ${OUT}
  fi  # ${DFMS}
done  # for
echo "  </TR>" >> ${OUT}

# Diagnostics, Last incomming
echo "  <TR>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-4'>Last incomming (by DFM)</FONT></TD>" >> ${OUT}
echo "    <TD><FONT COLOR=black face='verdana' size='-4'> </FONT></TD>" >> ${OUT}
for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  LASTDIR="`cd /appl/mdr/mdrglob/afsp/${COUNTRY}/incomming/; ls -1d 20??-??-??|tail -1`"
  echo "    <TD align='center'><FONT COLOR=black face='verdana' size='-4'> ${LASTDIR} </FONT></TD>" >> ${OUT}
done  # COUNTRY
echo "  </TR>" >> ${OUT}



echo "  <TR>" >> ${OUT}
echo "  </TR>" >> ${OUT}

echo "</TABLE>" >> ${OUT}


echo "  <TABLE>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Color legenda: </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>LifeCylce mgt: </TD>" >> ${OUT}
echo "      <TD > <FONT face= 'verdana' size=2>DASHBOARDASUPCOL</FONT> </TD>" >> ${OUT}
echo "      <TD > <FONT face= 'verdana' size=2>from data/dashboard.asc </FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Availability mgt: </TD>" >> ${OUT}
echo "      <TD BGCOLOR=red> <FONT face= 'verdana' size=2> < 14 days</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2> < 21 days</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2> < 28 days</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=lightgreen> <FONT face= 'verdana' size=2> <= 365 days</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2> > 365 days</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2> > 730 days (at least 1 Ontap upgrade had to be done)</FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Cap. mgt: </TD>" >> ${OUT}
echo "      <TD BGCOLOR=red> <FONT face= 'verdana' size=2>100%</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2> >= 95%</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2> >= 90%</FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "    <TR>" >> ${OUT}
echo "      <TD><FONT face= 'verdana' size=2>Failed disks: </TD>" >> ${OUT}
echo "      <TD BGCOLOR=""> <FONT face= 'verdana' size=2>0 failed disk</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=yellow> <FONT face= 'verdana' size=2>1 failed disk</FONT> </TD>" >> ${OUT}
echo "      <TD BGCOLOR=orange> <FONT face= 'verdana' size=2>more failed disks</FONT> </TD>" >> ${OUT}
echo "    </TR>" >> ${OUT}
echo "  </TABLE>" >> ${OUT}

echo "# ${PGM} v${VER}" >> ${CSV}
echo "# `date` `hostname`" >> ${CSV}
 
if [ ${MAIL} ] && [ -f ${CSV} ]; then
  date| mailx -a ${CSV} -s "AFSP Dashboard CSV [${PGM} v${VER}]" ${CSVMAILTO}
  echo "`date` Mailed to ${CSVMAILTO}"|tee -a ${LOG}
fi

# ----- Footer

echo "<TABLE BORDER=0 WIDTH='100%'>" >> ${OUT}
echo "<TR> " >> ${OUT}
echo "  <TD bgColor=#0066A1 > " >> ${OUT}
echo "    <FONT COLOR=white face='Verdana' size='1'>" >> ${OUT}
echo "      <CENTER>" >> ${OUT}
echo "Contact: |Content Owner: <A HREF="mailto:Maarten.deBoer@Atos.net">Maarten de Boer</A> |Last Update: `date`<BR>" >> ${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 "      </CENTER>" >> ${OUT}
echo "    </FONT>" >> ${OUT}
echo "  </TD>" >> ${OUT}
echo "</TR>" >> ${OUT}
echo "</TABLE>" >> ${OUT}

echo "</BODY>" >> ${OUT}
echo "</HTML>" >> ${OUT}


echo "`date` ${PGM} finished."|tee -a ${LOG}
exit 0

