vi /usr/local/scripts/tsm_log.ksh
LOGFILE=/tmp/tsm_log_kontrol.out
SEARCHFILE=/usr/local/scripts/exclude.lst
MFILE=/tmp/tsm_log.out.$$
kayit=0
echo "From: TSM Activity Log <xx>" > $MFILE
echo "Subject: TSM Activity Log Control" >> $MFILE
echo "To: [email protected]" >> $MFILE
echo "" >> $MFILE
#echo "Content-type: text/html; charset=US-ASCII" >> $MFILE
#echo "Content-transfer-encoding: 7BIT" >> $MFILE
#echo "<HTML><BODY>" >> $MFILE
#echo "<table border=1 style=\"font-size: 9pt; font-family: Tahoma\">" >> $MFILE
#echo "<tr><td>TSM Activity Log Analysis</td></tr>" >> $MFILE
dsmadmc -id=admin -password="xx" -outfile=$LOGFILE "select * from (select NODENAME,DATE_TIME,SEVERITY,MESSAGE from actlog where date_time>=current_timestamp-2 hours) where SEVERITY='D' OR SEVERITY='E' OR SEVERITY='W'"
if [ -r $LOGFILE ]
then
if [ -r $SEARCHFILE ]
then
#y=`echo $x | awk '{ print $1 }'`
while read x
do
say=`grep -E -p -v "$x" $LOGFILE|wc -l`
if [ $say -gt 0 ]
then
kayit=`expr $kayit + 1`
#echo "<tr><td>" >> $MFILE
grep -E -p -v "$x" $LOGFILE >> $MFILE
#echo "</td></tr>" >> $MFILE
fi
done < $SEARCHFILE
if [ $kayit -eq 0 ]
then
echo "No record found!" >> $MFILE
fi
#echo "</table>" >> $MFILE
#echo "</BODY></HTML>" >> $MFILE
say=`cat $MFILE|grep NODENAME|wc -l`
if [ $say -gt 0 ]
then
/usr/sbin/sendmail -t < $MFILE
/usr/bin/rm -f $MFILE
fi
fi
#/usr/bin/rm -f $LOGFILE
fi
and;
SEARCHFILE=/usr/local/scripts/exclude.lst
ANR0482W|ANR1401W|ANS8000I|ANR0516E|ANR0162W|ANR0516E|ANR2034E|StdPutText|OutDiagToCons|ANR2000E|ReportSQLDiagInfo|eportSQLDiagInfo|outDiagfExt|DbiEvalSQLOutcome|tbSQLExecuteSelect|NewAdmSQLExecute|AdmCommandLocal|SmAdminCommandThread|admCommand|tbSQLExecuteSelect|StartThread|ANR0568W|ANR8216W|ANR1404W|AdmSQLExecute|ANR2939E|Thread<13917>|issued message 9999 from|ANR2939E|ANE4037E|ANR0944E|ANR2022E DELETE PATH|ANR2024EA|ANR2020E|ANR4976W|S170SQLLOG|ANR8345E
Thanks
LOGFILE=/tmp/tsm_log_kontrol.out
SEARCHFILE=/usr/local/scripts/exclude.lst
MFILE=/tmp/tsm_log.out.$$
kayit=0
echo "From: TSM Activity Log <xx>" > $MFILE
echo "Subject: TSM Activity Log Control" >> $MFILE
echo "To: [email protected]" >> $MFILE
echo "" >> $MFILE
#echo "Content-type: text/html; charset=US-ASCII" >> $MFILE
#echo "Content-transfer-encoding: 7BIT" >> $MFILE
#echo "<HTML><BODY>" >> $MFILE
#echo "<table border=1 style=\"font-size: 9pt; font-family: Tahoma\">" >> $MFILE
#echo "<tr><td>TSM Activity Log Analysis</td></tr>" >> $MFILE
dsmadmc -id=admin -password="xx" -outfile=$LOGFILE "select * from (select NODENAME,DATE_TIME,SEVERITY,MESSAGE from actlog where date_time>=current_timestamp-2 hours) where SEVERITY='D' OR SEVERITY='E' OR SEVERITY='W'"
if [ -r $LOGFILE ]
then
if [ -r $SEARCHFILE ]
then
#y=`echo $x | awk '{ print $1 }'`
while read x
do
say=`grep -E -p -v "$x" $LOGFILE|wc -l`
if [ $say -gt 0 ]
then
kayit=`expr $kayit + 1`
#echo "<tr><td>" >> $MFILE
grep -E -p -v "$x" $LOGFILE >> $MFILE
#echo "</td></tr>" >> $MFILE
fi
done < $SEARCHFILE
if [ $kayit -eq 0 ]
then
echo "No record found!" >> $MFILE
fi
#echo "</table>" >> $MFILE
#echo "</BODY></HTML>" >> $MFILE
say=`cat $MFILE|grep NODENAME|wc -l`
if [ $say -gt 0 ]
then
/usr/sbin/sendmail -t < $MFILE
/usr/bin/rm -f $MFILE
fi
fi
#/usr/bin/rm -f $LOGFILE
fi
and;
SEARCHFILE=/usr/local/scripts/exclude.lst
ANR0482W|ANR1401W|ANS8000I|ANR0516E|ANR0162W|ANR0516E|ANR2034E|StdPutText|OutDiagToCons|ANR2000E|ReportSQLDiagInfo|eportSQLDiagInfo|outDiagfExt|DbiEvalSQLOutcome|tbSQLExecuteSelect|NewAdmSQLExecute|AdmCommandLocal|SmAdminCommandThread|admCommand|tbSQLExecuteSelect|StartThread|ANR0568W|ANR8216W|ANR1404W|AdmSQLExecute|ANR2939E|Thread<13917>|issued message 9999 from|ANR2939E|ANE4037E|ANR0944E|ANR2022E DELETE PATH|ANR2024EA|ANR2020E|ANR4976W|S170SQLLOG|ANR8345E
Thanks