#!/bin/ksh
# File	: proc_asup-files_for_info.sh
# By	: Maarten.deBoer@atos.net, 150925
# Subject	: Script to process ASUP-files for disk info
#set -x
#(0.2)	: Mode. ASUPDATADIR
PGM="`basename $0|cut -d\. -f1`" 
VER="0.2"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"
CSV="afsp-db-export-disks.csv"

#ASUPDATADIR="/appl/mdr/mdrglob/asup-data"
ASUPDATADIR="/appl/asup/data"

MAILTO="maarten.deboer@atos.net"

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

# Read Functions file
source ./afsp-db_functions.sh

DB_FUNC_VER

echo "# DB_SERIAL_NUMBER;MODELNAME;DB_CONTROLER_NAME;SERNR;SYSID;DISKCNT;DB_SNMP_LOCATION;COUNTRY;" > ${TMP}

for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  echo "${COUNTRY} ..."
  TTLCNT=0
  # If database, then cd to database
  if [ -d /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database ]; then
    cd /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database
	ls -1 | while read DBFILE
	do
#	  echo "${DBFILE} ..."
	  DB_READ ${DBFILE}

	  if [ "${DB_CONTROLER_NAME}" != "" ] && [ "${DB_SERIAL_NUMBER}" != "" ]; then
	    MODELNAME=""
		SERNR=""
		PARTNER=""
		BIOSVERSION=""
		DISKCNT=""

	    if [ -f ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-A.txt ]; then
		# Remove Spaces & CR's by sed
          MODELNAME="`cat ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-A.txt|grep 'Model Name:'|cut -d\: -f2|egrep 'FAS|N|V'|sed 's/ //g'|sed 's/\r//g'`"
	      SERNR="`cat ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-A.txt|grep 'System Serial Number:'|cut -d\: -f2|sed 's/ //g'|cut -d\( -f1`"
	      SYSID="`cat ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-A.txt|grep 'System ID:'|cut -d\: -f2|sed 's/ //g'|cut -d\( -f1`"
		fi  # -f

	    if [ -f ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-R.txt ]; then
		  DISKCNT="`cat ${ASUPDATADIR}/${DB_CONTROLER_NAME}_${DB_SERIAL_NUMBER}/SYSCONFIG-R.txt|egrep 'data|parity|spare  '| grep -v partner| wc -l`"
		  let "TTLCNT= ${TTLCNT} + ${DISKCNT}"

		fi  # -f

		echo "${DB_SERIAL_NUMBER};${MODELNAME};${DB_CONTROLER_NAME};${SERNR};${SYSID};${DISKCNT};${DB_SNMP_LOCATION};${COUNTRY}"|tee -a ${TMP}

	  fi  # NAME && SER.NR

	done  # FILE
  fi  # database
#  echo ";;;;;;${TTLCNT};${COUNTRY};"|tee -a ${TMP}
done  # ${COUNTRY}


cp ${TMP} /tmp/${CSV}
date | mailx -a /tmp/${CSV} -s "ASUP file info [${PGM} v${VER}]" ${MAILTO}

rm ${TMP} /tmp/${CSV}
echo "`date` ${PGM} Finished."|tee -a ${LOG}
exit 0