" >> ${PAGE}
echo " " >> ${PAGE}
# Check if a unknown-file has some information
cat ../data/unknown-systems_*.csv|grep -v ^#|awk -F\; '{print $2}'|sort -u|while read LINE
do
echo " ${LINE}
" >> ${PAGE}
done # cat
echo " | " >> ${PAGE}
echo " Country info ..."
cat ${CLUSTERFILE}|grep -v ^#|awk -F\; '{print $1}'|sort -u|while read COUNTRY REST
do
echo " ${COUNTRY} "
echo " " >> ${PAGE}
# selecte LAST file available
# selecte LAST file available
POOLSFILE=`grep "^${COUNTRY};" ${DATADIR}/country-systems-pools*.csv|cut -d\: -f1|sort -u|tail -1`
DISKSFILE=`grep "^${COUNTRY};" ${DATADIR}/country-systems-disks*.csv|cut -d\: -f1|sort -u|tail -1`
#echo "POOLSFILE=${POOLSFILE}"
#echo "DISKSFILE=${DISKSFILE}"
PROCDATE=`echo ${POOLSFILE}|cut -d\_ -f2|cut -d\. -f1`
if [ "${POOLSFILE}" != "" ] && [ "${DISKSFILE}" != "" ]; then
# ---------------------------------------
# SYStem
# country; system(cluster / HA)name; vendor ; SSD [GiB]; HDD [GiB]; Legay(7mode) [GiB]; "
cat ${POOLSFILE}|grep "^${COUNTRY};"|sort -u|grep -v ^#|sort|awk -F\; '{print $2,$3}'|while read CLUSTERNAME VENDOR REST
do
echo " ${CLUSTERNAME} (${VENDOR}) [${PROCDATE}]"
# When a SYStemNAME, then process for html-PAGE
if [ "${CLUSTERNAME}" != "" ]; then
# update DETAILs
DPAGE="${PAGEDIR}/${CLUSTERNAME}.html"
HTML_TOP ${DPAGE}
if [ -f ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_pools.csv ]; then
# nlnaf100;nlnaf100-01;n01a0601;hdd;100402
echo " ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_pools.csv"
echo " Details of ${CLUSTERNAME} pools (aggregates) : " >> ${DPAGE}
echo " " >> ${DPAGE}
echo " " >> ${DPAGE}
echo " | CLUSTERNAME | " >> ${DPAGE}
echo " SYSTEMNAME | " >> ${DPAGE}
echo " POOL(AGGR)-NAME | " >> ${DPAGE}
echo " TYPE | " >> ${DPAGE}
echo " SIZE_GB | " >> ${DPAGE}
echo " " >> ${DPAGE}
cat ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_pools.csv|sort -u|grep -v ^#|awk -F\; '{print $1,$2,$3,$4,$5}'|while read CLUSTERNAME SYSTEMNAME POOLNAME TYPE SIZE_GB REST2
do
echo " " >> ${DPAGE}
echo " | ${CLUSTERNAME} | " >> ${DPAGE}
echo " ${SYSTEMNAME} | " >> ${DPAGE}
echo " ${POOLNAME} | " >> ${DPAGE}
if [ "${TYPE}" = "ssd" ]; then
echo " ${TYPE} | " >> ${DPAGE}
else
if [ "${TYPE}" = "legacy" ]; then
echo " ${TYPE} | " >> ${DPAGE}
else
echo " ${TYPE} | " >> ${DPAGE}
fi
fi # TYPE
echo " ${SIZE_GB} | " >> ${DPAGE}
echo " " >> ${DPAGE}
done # cat .csv
echo " " >> ${DPAGE}
echo " | Name of location / cluster | " >> ${DPAGE}
echo " Name of the box / system | " >> ${DPAGE}
echo " Name of the pool of disken of one storage class | " >> ${DPAGE}
echo " Type of disks [sdd, hdd, hybrid, legacy] | " >> ${DPAGE}
echo " Size in GiB | " >> ${DPAGE}
echo " " >> ${DPAGE}
echo " " >> ${DPAGE}
fi # DETAILs _pools
# nlnaf100;X308_HMARK03TSSM;4;BSAS;2479
if [ -f ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_disks.csv ]; then
echo " ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_disks.csv"
echo " Details of ${CLUSTERNAME} disks : " >> ${DPAGE}
echo " " >> ${DPAGE}
echo " " >> ${DPAGE}
echo " | CLUSTERNAME | " >> ${DPAGE}
echo " DISKMODEL | " >> ${DPAGE}
echo " DISKCNT | " >> ${DPAGE}
echo " TYPE | " >> ${DPAGE}
echo " USABLE_GB | " >> ${DPAGE}
echo " | " >> ${DPAGE}
echo " PART-NR | " >> ${DPAGE}
echo " PWR | " >> ${DPAGE}
echo " TYPE | " >> ${DPAGE}
echo " MARKETING SIZE | " >> ${DPAGE}
echo " " >> ${DPAGE}
cat ${DETAILDIR}/${CLUSTERNAME}_${PROCDATE}_disks.csv|sort -u|grep -v ^#|awk -F\; '{print $1,$2,$3,$4,$5}'|while read CLUSTERNAME DISKMODEL DISKCNT TYPE USABLE_GB REST2
do
PART_NR=`grep ${DISKMODEL} ${DISKMODELINFO}|grep -v ^#|awk -F\; '{print $2}'|sort -u|head -1`
PWR=`grep ${DISKMODEL} ${DISKMODELINFO}|grep -v ^#|awk -F\; '{print $3}'|sort -u|head -1`
INFO_TYPE=`grep ${DISKMODEL} ${DISKMODELINFO}|grep -v ^#|awk -F\; '{print $4}'|sort -u|head -1`
MARKET_SIZE=`grep ${DISKMODEL} ${DISKMODELINFO}|grep -v ^#|awk -F\; '{print $5}'|sort -u|head -1`
echo " " >> ${DPAGE}
echo " | ${CLUSTERNAME} | " >> ${DPAGE}
echo " ${DISKMODEL} | " >> ${DPAGE}
echo " ${DISKCNT} | " >> ${DPAGE}
if [ "${TYPE}" = "SSD" ]; then
echo " ${TYPE} | " >> ${DPAGE}
else
echo " ${TYPE} | " >> ${DPAGE}
fi # TYPE
echo " ${USABLE_GB} | " >> ${DPAGE}
echo " | " >> ${DPAGE}
echo " ${PART_NR} | " >> ${DPAGE}
echo " ${PWR} | " >> ${DPAGE}
echo " ${INFO_TYPE} | " >> ${DPAGE}
echo " ${MARKET_SIZE} | " >> ${DPAGE}
echo " " >> ${DPAGE}
done # cat .csv
fi # DETAILs _disks
HTML_FOOTER ${DPAGE}
if [ "${HTMLMAILTO}" != "" ]; then
cat ${DPAGE}|mailx -s "html:${CLUSTERNAME}.html" ${HTMLMAILTO}
echo " Mailed ${CLUSTERNAME}.html to ${HTMLMAILTO}"|tee -a ${LOG}
fi
SSD_GB=`grep "${COUNTRY};" ${POOLSFILE}|grep "${CLUSTERNAME};"|sort -u|grep -v ^#|sort|awk -F\; '{print $4}'`
# Make TB's of it
if [ "${SSD_GB}" = "" ]; then
SSD_TB=0
else
SSD_TB=`expr ${SSD_GB} / 1024`
fi
HDD_GB=`grep "${COUNTRY};" ${POOLSFILE}|grep "${CLUSTERNAME};"|sort -u|grep -v ^#|sort|awk -F\; '{print $5}'`
# Make TB's of it
if [ "${HDD_GB}" = "" ]; then
HDD_TB=0
else
HDD_TB=`expr ${HDD_GB} / 1024`
fi
OLD_GB=`grep "${COUNTRY};" ${POOLSFILE}|grep "${CLUSTERNAME};"|sort -u|grep -v ^#|sort|awk -F\; '{print $6}'`
# Make TB's of it
if [ "${OLD_GB}" = "" ]; then
OLD_TB=0
else
OLD_TB=`expr ${OLD_GB} / 1024`
fi
echo " S:${SSD_TB}TiB(${SSD_GB}GB) H:${HDD_TB}TiB(${HDD_GB}GB) O:${OLD_TB}TiB(${OLD_GB}GB) "
echo " " >> ${PAGE}
echo " " >> ${PAGE}
# Calculate PCT for "bar"-graph
TTL_GB=`expr ${SSD_GB} + ${HDD_GB} + ${OLD_GB}`
if [ ${TTL_GB} -gt 0 ]; then
PCT1=`expr ${SSD_GB} \* 100 / ${TTL_GB}`
PCT2=`expr ${HDD_GB} \* 100 / ${TTL_GB}`
PCT3=`expr ${OLD_GB} \* 100 / ${TTL_GB}`
else
PCT1=0
PCT2=0
PCT3=0
fi
echo "${PCT1} ${PCT2} ${PCT3} / ${TTL}"
V=""
if [ "${VENDOR}" = "netapp" ]; then
V="N"
fi
if [ "${VENDOR}" = "emc" ]; then
V="E"
fi
if [ "${VENDOR}" = "hds" ]; then
V="H"
fi
#echo "VENDOR=${VENDOR} V=${V}"
# Count (SSD | HDD-)disks
NR_SSD=`grep "${COUNTRY};" ${DISKSFILE}|grep "${CLUSTERNAME};"|sort -u|grep -v ^#|sort|awk -F\; '{print $4}'`
NR_HDD=`grep "${COUNTRY};" ${DISKSFILE}|grep "${CLUSTERNAME};"|sort -u|grep -v ^#|sort|awk -F\; '{print $5}'`
if [ -f ${PAGEDIR}/${CLUSTERNAME}.html ]; then
echo " | ${V}:${CLUSTERNAME}: | " >> ${PAGE}
else
echo " ${V}:${CLUSTERNAME}: | " >> ${PAGE}
fi
echo " ${SSD_TB}(${NR_SSD}) | " >> ${PAGE}
echo " ${HDD_TB}(${NR_HDD}) | " >> ${PAGE}
echo " ${OLD_TB} | " >> ${PAGE}
echo " " >> ${PAGE}
echo " " >> ${PAGE}
fi # CLUSTERNAME <> ""
done # CLUSTERNAME
fi # POOLSFILE <> ""
echo " " >> ${PAGE}
done # ${CLUSTERFILE}
echo " " >> ${PAGE}
echo " " >> ${PAGE}
# EXTRA
echo "
" >> ${PAGE}
echo "" >> ${PAGE}
echo "
" >> ${PAGE}
echo "" >> ${PAGE}
echo " " >> ${PAGE}
echo " | Legenda: | " >> ${PAGE}
echo " | " >> ${PAGE}
echo " | " >> ${PAGE}
echo " " >> ${PAGE}
echo " " >> ${PAGE}
echo " E =  | " >> ${PAGE}
echo " H =  | " >> ${PAGE}
echo " N =  | " >> ${PAGE}
echo " " >> ${PAGE}
echo " " >> ${PAGE}
echo " | SSD TiB | " >> ${PAGE}
echo " HDD TiB | " >> ${PAGE}
echo " Legacy(N:7mode) TiB | " >> ${PAGE}
echo " Number of disks between () | " >> ${PAGE}
echo " " >> ${PAGE}
echo " " >> ${PAGE}
# When (explanation)TXT-file
if [ -f ${TXTFILE} ]; then
echo "
" >> ${PAGE}
echo " " >> ${PAGE}
cat ${TXTFILE}|while read LINE
do
echo "${LINE}
" >> ${PAGE}
done # TXTFILE
echo " " >> ${PAGE}
fi # TXTFILE
HTML_FOOTER ${PAGE}
# INPUTdir-overview
IPAGE="${PAGEDIR}/inputdir.html"
HTML_TOP ${IPAGE}
echo " " >> ${IPAGE}
HTML_FOOTER ${IPAGE}
if [ "${HTMLMAILTO}" != "" ]; then
cat ${PAGE}|mailx -s "html:decarbon.html" ${HTMLMAILTO}
cat ${IPAGE}|mailx -s "html:inputdir.html" ${HTMLMAILTO}
echo " Mailed HTML-pages to ${HTMLMAILTO}"|tee -a ${LOG}
fi
rm ${TMP}
echo "`date` ${PGM} ${VER} finished."|tee -a ${LOG}
exit 0
|