#!/bin/sh
# File	: chk_netapp-list.sh
# By	: Maarten.deBoer@Atos.net, 150818
# Subject	: Script to check AFSP-country-filers agains NetApp-lists
#
PGM="`basename $0|cut -d\. -f1`"
VET="0.1"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
COUNTRY="`echo ${BASEDIR}| cut -d\/ -f6`"

LOG="${BASEDIR}/log/${PGM}.log"
DBDIR="${BASEDIR}/data/database"
OUT="${BASEDIR}/data/${PGM}.csv"

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

NETAPP1="/appl/mdr/mdrglob/afsp/netapp/data/netapp-filer-list_2015-03-09.csv"
NETAPP2="/appl/mdr/mdrglob/afsp/netapp/data/netapp-filer-list_2014-03-25.csv"

echo "# AFSP(${COUNTRY})SerNr;Hostname;NetApp1-SerNr;NetApp2-Hostname;" > ${OUT}
cd ${DBDIR}
ls -1 *.asc| while read DBFILE
do
  DB_SERIAL_NUMBER="`grep ^SERIAL_NUMBER ${DBFILE}|awk -F\= '{print $2}'`"
  DB_CONTROLER_NAME="`grep ^CONTROLER_NAME ${DBFILE}|awk -F\= '{print $2}'`"

  if [ "${DB_SERIAL_NUMBER}" != "" ]; then
    CHK1="`cat ${NETAPP1}|grep ${DB_SERIAL_NUMBER}|awk -F\; '{print $5";"$8}'|grep ${DB_SERIAL_NUMBER}`"
    CHK2="`cat ${NETAPP2}|grep ${DB_SERIAL_NUMBER}|awk -F\; '{print $3";"$4}'|grep ${DB_SERIAL_NUMBER}`"
    echo "${DB_SERIAL_NUMBER};${DB_CONTROLER_NAME};${CHK1};${CHK2};"|tee -a ${OUT}
  else
    echo "  No SerNr for ${DBFILE}"|tee -a ${LOG} 
    echo "${DB_SERIAL_NUMBER};${DB_CONTROLER_NAME};;;;;;;"|tee -a ${OUT}
  fi


done  # ls -1

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