$HTML_VONAL" >> $TMP_HTML_FILE
}

control_c()
# run if user hits control-c
{
        echo -en "\n*** Ouch! Ertem a celzast, maris takaritok... ***\n"
        rm $TMP_FILE 2>/dev/null
        rm $TMP_HTML_FILE 2>/dev/null
        exit 1
}

# trap keyboard interrupt (control-c)
trap control_c SIGINT

# Hasznlat sztanzak ellenorzese
fejlec "Vizsgalando TSM sztanza konfigok mukodesenek ellenorzese"
for TSM_SZERVER in $TSM_SZERVEREK; do
        VER=$((`dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=$TSM_SZERVER q opt | sed -n -e 's/Server Version \([0-9]\),.*/\1/p' -e 's/[\t\s]*//g'`))
        LONG_VER=$(dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=$TSM_SZERVER q opt | sed -n -e  's/Server Version \([0-9]\), Release \([0-9]\), Level \([0-9]\)\.\([0-9]\).*/\1.\2.\3.\4/p' | sed -e 's/^[^0-9]*//g')
        LONG_VER=$(dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=$TSM_SZERVER q opt | sed -n -e  's/Server Version \([0-9]\), Release \([0-9]\), Level \([0-9]\+\)\.\([0-9]\+\).*/\1.\2.\3.\4/p' | sed -e 's/^[^0-9]*//g')
        TSM_SZERVERNEV[$TSM_SZERVER]=$(dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=$TSM_SZERVER q opt | sed -n -e 's/Session established with server \([^:]*\):.*/\1/p')
        if [ "$VER" != "0" ]; then
                OK="OK! (v${LONG_VER} - ${TSM_SZERVERNEV[$TSM_SZERVER]})"
                TSM_SZERVERNEVEK_TMP="$TSM_SZERVERNEVEK_TMP ${TSM_SZERVERNEV[$TSM_SZERVER]}"
                TSM_SZERVEREK_TMP="$TSM_SZERVEREK_TMP $TSM_SZERVER"
                TSM_SZERVER_VER="$TSM_SZERVER_VER $VER"
        else
                OK="Sikertelen! A szerver kihagyasra kerul a riportbol."
        fi
        echo "${TSM_SZERVER}: $OK" | awk -F'|' '{printf "> @%-35s %-12s\n",$1,$2}' | tee -a $TMP_HTML_FILE | tee -a $TMP_FILE
done
# Program torzs
if [ `echo $TSM_SZERVEREK | grep -c '[a-zA-Z]'` -eq 0 ]; then
        echo "$(date) Nincs hasznalhato sztanza a konfigomban." >> "$(dirname $0)/tsm_kliens_riport.err"
    rm $TMP_FILE 2>/dev/null
    rm $TMP_HTML_FILE 2>/dev/null
    exit 1
fi

# Vegigmegyunk az osszes konfig fajlon, ami a TSM_SZERVEREK valtozoban fel van sorolva
for TSM_SZERVER in $TSM_SZERVEREK; do
    KONFIG_FILE="$(dirname $0)/tsm_kliens_riport.$TSM_SZERVER"
    # Minden riport cimzettet felolvasunk az aktualis konfig fajlbol
    awk -F';' '/^[^#]/{print $1}' "$KONFIG_FILE" | sort -u | while read MAILTO; do
        level_fejlec;
        fejlec "${TSM_SZERVER}"
        html_vonal "Sikertelen utemezesek" >> $TMP_HTML_FILE
        echo "NODE NAME                 SCHEDULE NAME                        ACTUAL START             RUNTIME     RESULT" | tee -a $TMP_HTML_FILE >> $TMP_FILE
        echo "---------------------     --------------------------------     --------------------     --------    --------------"| tee -a $TMP_HTML_FILE >> $TMP_FILE
        # Minden adott email cimhez tartozo SQL feltetelt feldolgozunk, először csak a nem sikereseket, aztán alá a teljes listát is
        awk -F';' "/^[^#]*$MAILTO/"'{print $2}' $KONFIG_FILE | sort -u | while read SQL_FELTETEL; do
            FSIZE=$(ls -l $TMP_FILE | awk '{print $5}')
            if [[ "$SQL_FELTETEL" = "" ]]; then continue; fi
            dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=${TSM_SZERVER} -dataonly=y -displ=tabl "$SQL_Q_FAILED_EVENTS AND $SQL_FELTETEL" | egrep -v '(ANS|ANR)' | egrep '(Failed|Missed|Severed|Started)' | tee -a $TMP_HTML_FILE >> $TMP_FILE
#            FSIZE2=$(ls -l $TMP_FILE | awk '{print $5}')
        done
        html_vonal "
Elmult 3 napban sorozatosan Missed utemezesek" >> $TMP_HTML_FILE
        echo "NODE NAME                 SCHEDULE                       CONTACT                   3 DAY COUNT         LAST SEEN" | tee -a $TMP_HTML_FILE >> $TMP_FILE
        echo "---------------------     --------------------------     ---------------------     ------------     ------------" | tee -a $TMP_HTML_FILE >> $TMP_FILE
        # Minden adott email cimhez tartozo SQL feltetelt feldolgozunk, először csak a nem sikereseket, aztán alá a teljes listát is
        awk -F';' "/^[^#]*$MAILTO/"'{print $2}' $KONFIG_FILE | sort -u | while read SQL_FELTETEL; do
            FSIZE=$(ls -l $TMP_FILE | awk '{print $5}')
            if [[ "$SQL_FELTETEL" = "" ]]; then continue; fi
            SQL_3X_MISSED="select substr(e.node_name,1,20) as \"NODE NAME\", substr(e.schedule_name,1,25) as SCHEDULE, substr(n.contact,1,20) as \"CONTACT\", substr(char(count(*)),1,4) as \"3 DAY COUNT\",(days(current_timestamp)-days(n.lastacc_time)) as \"LAST SEEN\" from EVENTS e, nodes n where (e.scheduled_start >=current_timestamp - 3 days) and e.node_name=n.node_name and e.status='Missed' and e.node_name is not NULL and e.schedule_name not like 'RMAN_%%_LOG%%' and e.schedule_name not like 'SQL_%%_LOG%%' and $(echo ${SQL_FELTETEL} | sed 's/order by [^ ]*//gi') group by e.node_name, e.schedule_name, n.contact, n.lastacc_time having count(*)>=3 " #order by \"3 DAY COUNT\" desc"
            dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=${TSM_SZERVER} -dataonly=y -displ=tabl "$SQL_3X_MISSED" | egrep -v '(ANS|ANR)' | tee -a $TMP_HTML_FILE >> $TMP_FILE
#            FSIZE2=$(ls -l $TMP_FILE | awk '{print $5}')
        done
        html_vonal "
Minden utemezes" >> $TMP_HTML_FILE
        echo "NODE NAME                 SCHEDULE NAME                        ACTUAL START             RUNTIME     RESULT" | tee -a $TMP_HTML_FILE >> $TMP_FILE
        echo "---------------------     --------------------------------     --------------------     --------    --------------"| tee -a $TMP_HTML_FILE >> $TMP_FILE
        awk -F';' "/^[^#]*$MAILTO/"'{print $2}' $KONFIG_FILE | sort -u | while read SQL_FELTETEL; do
#            FSIZE=$(ls -l $TMP_FILE | awk '{print $5}')
            if [[ "$SQL_FELTETEL" = "" ]]; then continue; fi
            dsmadmc -id=$TSM_FELH -pa=$TSM_JELSZO -se=${TSM_SZERVER} -dataonly=y -displ=tabl "$SQL_Q_FAILED_EVENTS AND $SQL_FELTETEL" | egrep -v '(ANS|ANR)' | tee -a $TMP_HTML_FILE >> $TMP_FILE
            FSIZE2=$(ls -l $TMP_FILE | awk '{print $5}')
            if [[ $FSIZE -ne $FSIZE2 ]]; then echo "$HTML_VONAL" >> $TMP_HTML_FILE; fi
        done
        ENDTIME=`date "+%s"`
        echo "$HTML_TABLA_LABLEC" >> $TMP_HTML_FILE
        echo "[A riport $((($ENDTIME-$STARTTIME)/60)) perc $((($ENDTIME-$STARTTIME)%60)) mp alatt keszult el - TSM riporter $SCRIPT_VER]" | tee -a $TMP_HTML_FILE >> $TMP_FILE
        # Riport kuldese
        DATUM=`date +"%F_%H-%M"`
        mkdir -p $LOG_DIR >/dev/null
        if [ $? -eq 0 ]; then
            cp $TMP_FILE $LOG_DIR/tsm_kliens_riport_${DATUM}_${MAILTO}.log
            echo "

[A riport szoveges valtozata az alabbi utvonalon helyben is le lett tarolva:
 "`hostname`":$LOG_DIR/tsm_kliens_riport_${DATUM}_${MAILTO}.log]" >> $TMP_HTML_FILE
            ERR=$?
        fi
        if [[ $ERR -ne 0 || ! $ERR ]]; then
            echo "HIBA: A riportot nem sikerult a $LOG_DIR mappaba menteni!" >>$TMP_HTML_FILE
        fi
        echo "$HTML_MODUL_LABLEC" >> $TMP_HTML_FILE
        # Levelkuldes
        sed -i -e 's/^|//' -e 's/|$//' $TMP_HTML_FILE
        sed -i 's/^.*4-Skipped Files.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i 's/^.*8-Warnings.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i 's/^.*12-Errors.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i 's/^.*-Failed.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i 's/^.*-Missed.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i 's/^.*-Started.*$/&<\/font>/' $TMP_HTML_FILE # TSM sztanza szinzes
        sed -i -e "s/___*[^_]*___*/&<\/div>/" -e 's/___//g' $TMP_HTML_FILE # Szekcio fejlec szinezes

        echo -e "${JS_CODE}\n$(cat ${TMP_HTML_FILE})" > $TMP_HTML_FILE
        if [ `echo "$MAILTO" | grep "@.*\."` ]; then
        if [[ `which sendmail` && $HTML_EMAIL -eq 1 ]]; then
            echo -e "To: $MAILTO\nMIME-Version: 1.0\nContent-Type: text/html\nContent-Disposition: inline\nSubject: TSM kliens riport ($TSM_SZERVER)\n$(cat ${TMP_HTML_FILE})" > $TMP_HTML_FILE
            cat $TMP_HTML_FILE | sendmail -B 8BITMIME -t -F "TSM riporter"
        elif [[ ! $HTML_EMAIL -eq 1 && $HTML_EMAIL_CSAT -eq 1 ]]; then
            echo -e "To: $MAILTO\nSubject: TSM kliens riport ($TSM_SZERVER)\n$(cat $TMP_FILE)" > $TMP_FILE
            cp $TMP_HTML_FILE /tmp/tsm_kliens_riport_${DATUM}.html
            cat $TMP_FILE | mailx -a /tmp/tsm_kliens_riport_${DATUM}.html -t
        else
            echo -e "To: $MAILTO\nSubject: TSM kliens riport ($TSM_SZERVER)\n$(cat $TMP_FILE)" > $TMP_FILE
            cat $TMP_FILE | mailx -t
        fi
    fi
    done
done
# Regi logok torlese
zip -9rv ${LOG_DIR}/$(date +%Y%m)_archived_backup_logs.zip "${LOG_DIR}/tsm_kliens_riport_${DATUM}_${MAILTO}.log"
find ${LOG_DIR}/tsm_kliens_riport_*.log -type f -mtime +60 -exec rm {} \;
rm -f "$TMP_FILE" "$TMP_HTML_FILE" "/tmp/tsm_kliens_riport_${DATUM}.html"