#/bin/sh
# File	: netapp-cdot-mysql-rpt-disklist.sh
# By	: Maarten.deBoer@Atos.net, 210324
# Subject	: Script to report disktypes (for DeCarbon) from cDOT-mysql-DB
PGM=`basename $0|cut -d\. -f1`
VER="0.1"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"
#MAILTO="nl19471@nlxnetapp01.bcklan.ao-srv.com maarten.deboer@atos.net"
MAILTO="maarten.deboer@atos.net"
SUBJECT="${PGM}: `hostname` at `date` [${PGM} v${VER}]"
CSV="/tmp/${PGM}.csv"

MYSQL="/usr/bin/mysql"
DBHOST="localhost"
DBPORT="3305"
DBNAME="ocum"
# ReadOnly user
USERNAME="ocumdbuser"
# PASSWORD stored in ${HOME}/.my.cnf (chmod 600) as password=<password>

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

${MYSQL} --bind-address="${DBHOST}" -P ${DBPORT} --user=${USERNAME} --database="${DBNAME}" -B -e "select clustername,ownernodename,shelf,bay,vendorname,model,disktype,totalBytes from disklivelistdtoview"|awk '{print $1";"$2";"$3";"$4";"$5";"$6";"$7";"$8";"$9";"}'|sort >> ${CSV} 2>>${LOG}

echo "# `date` by ${PGM} v${VER} at `hostname`." >> ${CSV}

if [ -s ${CSV} ]; then
  date| mailx -a ${CSV} -s "${SUBJECT}" ${MAILTO}
  LINES=`cat ${CSV}|wc -l`
  echo "  Mailed ${LINES} line(s) in ${CSV} to ${MAILTO}"|tee -a ${LOG}
fi

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