#!/bin/sh
# File	: chk_asup_vs_db.sh
# By	: Maarten.deBoer@Atos.net, 150903
# SUbject	: Script to check ASUP input vs AFSP-DB
#(0.2)	: Changed SNMPLOC & SNMPCONTACT
PGM="`basename $0|cut -d\. -f1`"
VER="0.2"
TMP="/tmp/${PGM}.$$"

BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
ETCENV="${BASEDIR}/etc/afsp.env"
LOG="${BASEDIR}/log/${PGM}.log"

ASUPDIR="/appl/mdr/mdrglob/afsp/glob/data/asup"

ASUPIN="${BASEDIR}/data/asup-data.csv"

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

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

echo "Collecting of all countries; hostname & ser.nr ..."
echo "# {COUNTRY};{DB_CONTROLER_NAME};{DB_SERIAL_NUMBER};{DB_SYSTEM_ID};" > ${TMP}

for COUNTRY in `cd /appl/mdr/mdrglob/afsp/; ls -1d ??`
do
  for DBFILE in `ls -1 /appl/mdr/mdrglob/afsp/${COUNTRY}/data/database/*.asc`
  do
    DB_READ ${DBFILE}
    echo "${COUNTRY};${DB_CONTROLER_NAME};${DB_SERIAL_NUMBER};${DB_SYSTEM_ID};" >> ${TMP}
  done  # DBFILE
done  # COUNTRY

# Read ASUP-files
cat ${ASUPIN}|sort|grep -v ^#|while read LINE
do
  FILER="`echo ${LINE}| awk -F\; '{print $1}'`"
  LOC="`echo ${LINE}|awk -F\, '{print $2}'|cut -d' ' -f1`"
  OSVERSION="`echo ${LINE}|awk -F\; '{print $4}'`"
  FWVERSION="`echo ${LINE}|awk -F\; '{print $5}'|sed 's/ //g'`"
  SERNR="`echo ${LINE}|awk -F\; '{print $6}'|sed 's/ //g'`"
  PARTNER="`echo ${LINE}|awk -F\; '{print $7}'|sed 's/ //g'`"
  SNMPLOC="`echo ${LINE}|awk -F\; '{print $2}'`"
  SNMPCONTACT="`echo ${LINE}|awk -F\; '{print $8}'|sed 's/ //g'`"
  LASTASUPDATI="`echo ${LINE}|awk -F\; '{print $9}'`"

  # Get country
  if [ "${FILER}" != "" ]; then
    FILERCOUNTRY="`grep ${FILER} ${TMP}|awk -F\; '{print $1}'`"
  fi  # HOSTNAME

  if [ "${FILERCOUNTRY}" = "" ]; then
    echo "  New filer ${FILER} ${SERNR}. Creating new DB-file"
	DB_SERIAL_NUMBER=${SERNR}
	DB_CONTROLER_NAME=${FILER}
	DB_MODEL_NAME="?"
	DB_OS_VERSION=${OSVERSION}
	DB_PARTNER_HOSTNAME=${PARTNER}
	DB_SNMP_CONTACT=${SNMPCONTACT}
	DB_SNMP_LOCATION=${SNMPLOC}
	DB_ASUP_GENERATED_ON=${LASTASUPDATI}
	DB_SYSTEM_ID="?"

	if [ "${SERNR}" != "" ]; then
	  DB_WRITE ${BASEDIR}/data/database/${SERNR}.asc
	else
	  DB_WRITE ${BASEDIR}/data/database/${FILER}.asc
	fi

  fi  # <> FILERCOUNTRY

done  # cat ${ASUPIN}

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