#!/bin/sh
# FIle	: proc_processed-mdr-data.sh
# By	: MaartenDeBoer.nl, 210325
# Subject	: Script to process processed-MDR-data
#(0.2),210326	: Add 2nd proc part & mailx
PGM=`basename $0|cut -d\. -f1`
VER="0.2"
TMP="/tmp/${PGM}.$$"
TMPDIR="/tmp/${PGM}"
HOSTNAME=`hostname|cut -d\. -f1`
DATI=`date +%Y-%m-%d-%H-%M-%S`
MAILTO="nl19471@nlxnetapp01.bcklan.ao-srv.com"
CSV="${TMPDIR}/netapp-mdr-proc-rpt_${HOSTNAME}_${DATI}_cdot-disks.csv"

FILTER="*"
#FILTER="ustxca30040sto"
#FILTER="us"
PROCDIR="/appl/mdr/inventory1/data/import/filerdata/processed"


echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
touch ${TMP}

# Clean & create TMPDIR
if [ -d ${TMPDIR} ]; then
  rm -rf ${TMPDIR}
fi
mkdir -p ${TMPDIR}

# NetApp (filerdata)
ls -1 ${PROCDIR}/*${FILTER}*.tar.gz|while read FNAME
do
  echo "   FNAME=${FNAME}"
# Get a list of disk(.ASC)-files
  tar tzf ${FNAME}|grep disk | grep -v .csv > ${TMP}
# Extract the disk files. Is when data in TMP (-s)
  if [ -s ${TMP} ]; then
    cd ${TMPDIR}
    tar -T ${TMP} -xvzf ${FNAME} 
  fi  # -s ${TMP}
done  # ls -1

echo "${TMPDIR}/appl/mdr/inventory1/data/import/filerdata"

# NetApp
# netapp-rpt-de-carbon-kpi-s_smctustor55_<dati>_cdot-disks.csv
# disk;owner;aggregate;model;type;usable-size;

# get disk info from files
# Disk                   Size Shelf Bay Type    Type        Name      Owner
cd ${TMPDIR}/appl/mdr/inventory1/data/import/filerdata
ls -1 *|while read FNAME
do
  echo "  FNAME=${FNAME}"
  echo "# disk;owner;aggregate;model;type;usable-size;" >> ${CSV}
  if [ -s ${FNAME} ]; then
    egrep "SAS|ATA|SSD" ${FNAME}| while read LINE
    do
      echo "${LINE}"
      DISK=`echo ${LINE}|awk '{print $1}'`
      USABLE_SIZE=`echo ${LINE}|awk '{print $2}'`
      SHELF=`echo ${LINE}|awk '{print $3}'`
      BAY=`echo ${LINE}|awk '{print $4}'`
      DISK_TYPE=`echo ${LINE}|awk '{print $5}'`
      CONTAINER_TYPE=`echo ${LINE}|awk '{print $6}'`
      CONTAINER_NAME=`echo ${LINE}|awk '{print $7}'`
      OWNER=`echo ${LINE}|awk '{print $8}'`

      SYSNAME=`echo "${FNAME}"|cut -d\_ -f1`
# disk;owner;aggregate;model;type;usable-size;
      echo "${DISK};${SYSNAME};-;unknown;${DISK_TYPE};${USABLE_SIZE};" | tee -a ${CSV}

    done  # read LINE
  fi  # -s FNAME
done  # ls -1

if [ -s ${CSV} ] && [ "${MAILTO}" != "" ]; then
  echo "  Mailing CSV (${CSV}) to ${MAILTO}"|tee -a ${LOG}
  date | mailx -a ${CSV} -s "netapp-rpt-de-carbon-kpi-s: from ${HOSTNAME} `date`" ${MAILTO} 

fi


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