Shell Programming and Scripting

Hi All,

I've a log file call netbackup.log in all the 5 servers in location usr/netbackup.log. I dont want to login in each server and check the log file. So i wanted to have a script written to have the log information at one place.

I want to have the last 2 lines from the file netbackup.log from all the servers and write in a new log file using ssh and send a mail.

Can anyone plz help me out how to write a script which connects a another unix system and get the last 2 lines of a particular log file.

Thanks in advance.
Suri tyson

1. Enter this "ssh without password" in your favourite internet search engine and set it up accordingly between your collecting server and all the other servers you gonna ask for the Netbackup logs.
2. Write a script that could look like this:

Code:

RESULTFILE=/myoutfile
HOSTLIST="hosta hostb hostc hostd"

if [[ -e ${RESULTFILE} ]]; then
   rm -f ${RESULTFILE}
fi

for HOSTR in ${HOSTLIST}; do
   echo ${HOSTR} >> ${RESULTFILE}
   ssh -o "batchmode" myuser@${HOSTR} "tail -2 /where/is/my/netbackup.log" >> ${RESULTFILE}
   if (( $? != 0 )); then
      echo "Something went wrong with ssh to Host ${HOSTR}, check the logs!"
   fi
done

(echo "Here comes the mail again.."; uuencode ${RESULTFILE} ${RESULTFILE}) | mail -s "Some subject" myaddress@somedomain.org

exit 0

Hi Zaxxon, thanks it worked;however would like to know one more thing...

I've made it possible by using two scripts.

1.)test_ssh1.sh

#!/bin/ksh
RESULTFILE=/oracle/PC9/netbackup.log
if [[ -e ${RESULTFILE} ]]; then
rm -f ${RESULTFILE}
fi


/usr/sap/sapshare/scripts/test_ssh2.sh Q03 sf2dom1

/usr/sap/sapshare/scripts/test_ssh2.sh D01 sol5500

/usr/sap/sapshare/scripts/test_ssh2.sh D02 jdcss039




2.)test_ssh2.sh


#!/bin/ksh

##############################################################################################
export ORACLE_SID=$1
export primaryhost=$2
export sid=`echo $ORACLE_SID| tr ['A-Z'] ['a-z']`
##############################################################################################

RESULTFILE=/oracle/PC9/netbackup.log

#############################################################################################
## Step 1 - Get the last created backup log
#############################################################################################
ssh -l ora${sid} ${primaryhost} "tail -2 /oracle/$ORACLE_SID/newbackup/sap_netbackup.log" >> ${RESULTFILE}

exit 0

And then it sends the mail.. looks like this

Oracle Q03 End Hot BACKUP Time: 07/23/08 14:18:15
Oracle Q03 Begin Hot BACKUP Time: 07/24/08 18:35:46
Oracle D01 Begin Hot BACKUP Time: 07/11/08 21:00:48
Oracle D01 End Hot BACKUP Time: 07/12/08 17:28:24
Oracle D02 Begin Hot BACKUP Time: 07/23/08 21:01:23
Oracle D02 End Hot BACKUP Time: 07/24/08 01:32:32

However i want to read the last line of the log file with name End Hot BACKUP and calculate the time taken from Begin Hot BACKUP to End Hot BACKUP and display the difference in hours/minutes.